PdfPrep.com

How should you complete the Transact-SQL statement?

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

Exit mobile version