I need a query to link ProductId to CategoryName for ps3
Hello I am using powerstore3.
I need to create a VIEW and export to CSV an output of a relation between my ps3_products.ProductID to the ps3_categories.CategoryID and ps3_categories.CategoryName. ...Now, the "ps3_productcategories table" has a ProductID.
I need to know how to write the "JOIN" or "what type of JOIN" in MySQL
It starting to look like spaghetti to me now.
So here goes, I have three tables......
1. ps3_categories [ CategoryID, CategoryName, CategoryParent ]
2. ps3_productcategories [ ProductCategoryID, CategoryID, ProductID ]
3. ps3_products [ ProductID, ProductName, ProductSKU, ...etc ]
I want to correllate the Product IDs ===>>> CATEGORY ID ===>>>>CATEGORY NAMES,
ANY help will be appreciated,