select dpt.Dept_Id , dpt.Dept_Name,dpt.Dept_Location, inst.Ins_Name as [Dept_Manager] ,dpt.Dept_Desc from Department dpt join Instructor as inst on (dpt.Dept_Id=3) AND ((dpt.Dept_Manager = inst.Ins_Id) OR (dpt.Dept_Manager is null))
SELECT * FROM Department d LEFT JOIN Instructor i ON d.dept_manager = i.ins_id WHERE d.dept_id = 3
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)