reriving records from multiple tables.

[lokendra]

hi all,


in oracle,

one table 'n1' contains deportments as "a, b, c, d" and another table 'n2' contains employees as "x , y, z".

table n1 table n2
------------ -----------------
a x
b y
c z
d -

deportment "d", does not contain any employ.

MY QUESTION IS,

HOW CAN I RETRIVE THE FOUR RECORDS FROM N1,N2 BY USING JOINS?

[subashini Thiyagarajan]

http://www.1keydata.co m/sql/sqljoins.html

http://www.skillbuilde rs.com/Tutorials-V2/ora9i_SQL_Decod e_Case/ora9i_SQL_Decod e_Case.cfm

Please refer these URL's for solution