Home » SQL & PL/SQL » SQL & PL/SQL » outer joins
outer joins [message #206986] Sun, 03 December 2006 00:58 Go to next message
BigLearner
Messages: 10
Registered: December 2006
Junior Member
hai everyone,

can someone explain to me how + works against right and left outer join

my book and the articles that i see on the web are contradicting.

dept.deptno (+) = emp.deptno

records from emp would be returned even if no corresponding records exists in dept. is this left join or right join?

big learner
Re: outer joins [message #207062 is a reply to message #206986] Mon, 04 December 2006 01:12 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
it is left outer join
Previous Topic: dynamic sql problem
Next Topic: Minus to Not Exists
Goto Forum:
  


Current Time: Wed Dec 07 02:55:38 CST 2016

Total time taken to generate the page: 0.13042 seconds