In a database with a Products table and Orders table,you want to see which products have not been ordered.What type of query should you create?
A) Select query with a self join.
B) Update query.
C) Select query with an outer join.
D) Append query.

Question

Quizplus · Accepted Answer

An outer join can be used to see all records in the Products table, even those that do not have a matching record in the Orders table. Specifically, we would want to use a left outer join where the Products table is on the left side and the Orders table is on the right side. This will include all products, and for those that have not been ordered, the corresponding fields in the Orders table will be null.

In a Database with a Products Table and Orders Table,you