Home » SQL & PL/SQL » SQL & PL/SQL » outer joins
outer joins [message #206986] Sun, 03 December 2006 00:58 Go to next message
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
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: Thu Jul 20 21:53:26 CDT 2017

Total time taken to generate the page: 0.10726 seconds