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.

Outer Join

A type of SQL join that includes all rows from one or both of the participating tables even if they do not meet the join condition.

Products Table

A database table that stores information about products, including descriptions, prices, and quantities.

Orders Table

A table in a database that stores information about customer orders, including details like order date, products ordered, and quantities.