SELECT ProductName, CategoryName
FROM Products, Categories

SELECT ProductName, CategoryName
FROM Products, Categories
WHERE Products.CategoryID = Categories.CategoryID