HOTSPOT
A company creates marketing photographs of products for online retailers. Photographs and related information are stored in a database that has the following structure:
You must create a report that returns a list of all product photos, and whether the product has a primary
photo.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.
NOTE: Each correct selection is worth one point.
Answer: Explanation:
Box 1: LEFT JOIN We want a list of all product photos, and whether the product has a primary photo.
Box 2: FULL OUTER JOIN The FULL OUTER JOIN keyword return all records when there is a match in either left (table1) or right (table2) table records.
Box 3: AND