SQL Join Syntex
SELECT table1.column1,table1.column2,table2.column3
FROM table1
LEFT JOIN table2
ON table1.common_column = table2.common_column;
SQL Statement
SELECT Department.DepartmentName,Employee.Name,
Employee.Email,Employee.PhoneNumber,Employee.Salary
FROM Department
LEFT JOIN Employee
ON Department.ID = Employee.DepartmentId