here ya go:
SELECT ps3_categories.CategoryName, ps3_products.ProductID, ps3_products.ProductName
FROM ps3_categories
INNER JOIN ps3_productcategories ON ps3_categories.CategoryID = ps3_productcategories.CategoryID
INNER JOIN ps3_products ON ps3_products.ProductID = ps3_productcategories.ProductID