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: 64103
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: Sat Dec 03 11:51:03 CST 2016

Total time taken to generate the page: 0.07367 seconds