LEFT JOIN
All rows from the left table will be returned, even if there's no matching row in the right table.

RIGHT JOIN
All rows from the right table will be returned, even if there's no matching row in the left table.

INNER JOIN
Only returns rows where there's a matching row in both tables.

1
2
3
SELECT Employee.EmpID, Employee.EmpFname, Employee.EmpLname, Projects.ProjectID, Projects.ProjectName
FROM Employee
INNER JOIN Projects ON Employee.EmpID=Projects.EmpID;