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: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference, JOINS

Regards
Michel
Previous Topic: how to use the & symbol in text (merged)
Next Topic: Need Help With Simple PL/SQL Script
Goto Forum:
  


Current Time: Sun Aug 20 16:16:25 CDT 2017

Total time taken to generate the page: 0.05326 seconds