0894c976616e0f05ee322d33a5977f149e26b11a0669350a88167180fd9ba5d31

SELECT e.EmployeeID, e.Employee_Name, e.Employee_Salary, d.DepartmentID, d.Department_Name FROM employee e LEFT OUTER JOIN department d ON e.EmployeeID = d.Employee_ID;