I have a problem with outer joins. Hope some one can help me.
the query:

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

My mistake,

The query I posted doesn't seem to have the same problem. I'm working with a large query so I quess I made a mistake some where else.

Thanx, anyway,
Neil