I have 3 tables that I want to combine, see below for details:
product
- productID
- name
- price
prod_cat
- productID
- categoryID
category
- categoryID
- name
joined
product.productID category.categoryID product.name product.price category.name(each one though, since a product can belong to more than one category)
What I want to do is get each product with the categories that relate to them in a single query. How would I got about this?
See Question&Answers more detail:os