Question

Write an SQL statement to display the SKU, SKU_Description, and Department of all SKUs that appear in either the Cape Codd 2013 catalog (either in the printed catalog or on the Web site) or the Cape Codd 2014 catalog (either in the printed catalog or on the Web site) or both.

Answer 1

SELECT SKU_SKU Description, Department

FROM Catalog_SKU_2013

WHERE CatologPage IS NOT NULL

UNION

SELECT SKU, SKU_Description, DepartmentFrom Catalog_SKU_2014

WHERE CatologPage IS NOT NULL