-----Original Message-----
From: Jitendra Kumar [mailto:jitendra.[Email address protected]
Sent: Monday, February 28, 2005 9:44 AM
To: 'thirumaran '
Subject: RE: outer joins in db2


Dear Thirumaran,
outer join in db2 is as


select a.emp_name, b.dep_name
from EMP a
LEFT OUTER JOIN DEP b
ON
a.dep_id = b.dep_id
and b.active_ind = 'Y';

or

select a.emp_name, b.dep_name
from DEP b
RIGTH OUTER JOIN EMP a
ON
a.dep_id = b.dep_id
and b.active_ind = 'Y';


With regards,
Jitendra Kumar
Software Engineer


-----Original Message-----
From: thirumaran
[mailto:db2udbdba-ezmlmshield-x19010290.[Email address protected]
Sent: Saturday, February 26, 2005 1:34 PM
To: LazyDBA Discussion
Subject: outer joins in db2


HI,

How can i rewrite the below statement in DB2 UDB V 8.2 FOR WINDOWS,AIX.

select a.emp_name, b.dep_name
from EMP a,
DEP b
WHERE a.dep_id = b.dep_id (+)
AND b.active_ind (+) = 'Y'


Thanks
Thirumaran
Thanks

Thirumaran


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page