August 3, 2009 at 6:43 am
There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?
August 3, 2009 at 6:55 am
The query will need a LEFT JOIN
August 3, 2009 at 1:24 pm
Not working!
can u plz explain how it works?
August 3, 2009 at 1:44 pm
How is it not working?! Are you getting an error? Are you not getting the results you are expecting?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply