|
|
| Re: outer join in an or statement [message #374866 is a reply to message #374865] |
Mon, 09 July 2001 04:03  |
murarishettysrinivas
Messages: 9
Registered: July 2001
|
Junior Member |
|
|
when ur having an outer join and have more than one condition we should have that (+) sign for all the conditions.
try out the following.
select x.ename,y.ename,z.ename
from emp x,emp y,emp z
where x.empno = y.mgr (+)
and y.empno = z.mgr (+)
or
select x.ename,y.ename,z.ename
from emp x,emp y,emp z
where x.empno = y.mgr (+)
or y.empno = z.mgr (+)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
