Listing 2: View and Base-Table Queries That Include a WHERE Clause
-- View query
SELECT *
FROM dbo.ProductCategoryDetailsView
WHERE CategoryName = 'Beverages'

-- Base-table query
SELECT CAT.CategoryName,
   P.ProductName,
   OD.Quantity,
   O.OrderID,
   C.CompanyName
FROM dbo.Orders AS O
   INNER JOIN dbo.[Order Details] AS OD
      ON O.OrderID = OD.OrderID
   INNER JOIN dbo.Products AS P
      ON P.ProductID = OD.ProductID
   INNER JOIN dbo.Categories AS CAT
      ON P.CategoryID = CAT.CategoryID
   INNER JOIN dbo.Customers AS C
      ON C.CustomerID = O.CustomerID
WHERE CategoryName = 'Beverages'