You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table. A sample of the data in Orders is shown in the following table. You need to create…

A Right Anti join returns only rows from the right table that have no matching rows in the left table, which is the opposite of the requirement.

A Right Outer join returns all rows from the right table and matching rows from the left table, which would not include customers without orders if `Customer` is the left table.

A Left Anti join returns only rows from the left table that have no matching rows in the right table, which would only show customers who have no orders.

A Left Outer join returns all rows from the first (left) table, `Customer`, and the matching rows from the second (right) table, `Orders`. If there is no match in `Orders` for a customer, the columns from the `Orders` table will show `NULL` values. This perfectly matches the requirement to show all customers, whether they have orders or not, alongside their order details.

An Inner join returns only the rows where there is a match in both tables, thus excluding any customers who have no orders.