SELECT * FROM Categories
WHERE Category <> 'Dummy'
SELECT * FROM Products
WHERE ItemID > 1
SELECT Products.*,Categories.* FROM Products
INNER JOIN Categories on Products.CategoryID = Categories.CategoryID
WHERE Products.CategoryID = WHERE Products.SubCatID = AND Products.SubCatID = 0
WHERE Products.SubCatID = WHERE Products.SubCatID =
ORDER BY Products.CategoryID,Products.ItemName
SELECT * FROM Categories
WHERE EXISTS
(SELECT Products.*,Categories.* FROM Products
INNER JOIN Categories on Products.CategoryID = Categories.CategoryID)
ORDER BY Categories.Category