Two outer joins
I have a problem with outer joins. Hope some one can help me.
select isNull(B.ID, -1), isNull(C.ID, -1), A.name from tbl_employee as A left outer join tbl_department as B on A.depID = B.depID left outer join tbl_room as C on A.roomID = C.roomID
The problem is when the join on table B as well as the join on table C 'works' I get two rows returned.
I only want one row.
Hope some one can help, Thanx, Neil