Inner Join: The INNER JOIN keyword returns only rows with a match in both tables. Left Join: The LEFT JOIN keyword returns all records from the left table (Customers), even if there are no matches in the right table (Orders). Right Join: The RIGHT JOIN keyword returns all records from the right table (Employees), even if there are no matches in the left table (Orders). Full Join: The FULL OUTER JOIN keyword returns all matching records from both tables whether the other table matches or not. So, if there are rows in "Customers" that do not have matches in "Orders", or if there are rows in "Orders" that do not have matches in "Customers", those rows will be listed as well.