Hi, yep im stuck, I made this query here
select * from PRODUCTS inner join link on link.prodID = PRODUCTS.productID where link.sysID=1
that joins 2 tables, i need to acquire more information off that query.
I have a category table, where the fields are ID & name and the PRODUCTS table has a field called CategoryID so basically (and im not sure how to) i want to modify my exisiting query so i can set a categoryID aswell as link.sysID=1
So basically i can then show each product under a header for its category where sysID=1
In short the result would be like:
System ID 1 has 2 Categories