Question

14. Another customer calls in requesting all of your seafood products. Note that he only wants the name of the product in his report – not all of the fields. [Hint: You will need to join the Products table to the Categories table to get this information. Your WHERE clause should include the criterion “WHERE CategoryName = "Seafood".]

Answer 1

As given in the hint,we need to perform inner join Products table with Categories table on the common key column (i.e. Category Id) and then apply where clause to have 'Seafood' in it.

SELECT ProductName
FROM Products
INNER JOIN Categories
ON Products.CategoryId = Categories.CategoryId
where Categories.CategoryName = 'Seafood'