Home » SQL & PL/SQL » SQL & PL/SQL » diff between natural and inner join
diff between natural and inner join [message #328211] Thu, 19 June 2008 06:45 Go to next message
krithi86
Messages: 19
Registered: June 2008
Location: India
Junior Member
hi

wat is d difference between inner join and natural join?

i have 2 tables emp1 and emp2.

emp1

eno number
ename varchar2(15)
deptno number

emp2

eno number
ename varchar2(15)
deptno number
hiredate date

if my query is like

select * from emp1 NATURAL JOIN emp2;

what will be my result n wat is the significance?
Re: diff between natural and inner join [message #328216 is a reply to message #328211] Thu, 19 June 2008 06:53 Go to previous message
Michel Cadot
Messages: 64822
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference, JOINS

Regards
Michel
Previous Topic: Pls tell me the difference between these 2 queries...??
Next Topic: Explain Plan Vs set autotrace Vs Tkprof
Goto Forum:
  


Current Time: Wed May 24 12:48:51 CDT 2017

Total time taken to generate the page: 0.09819 seconds