PHP SQL - 加入三个表

Question

I have three tables called product, product_category and category with product_category being the linking table.

How can I join these tables using SQL in PHP?

The linking table has only productID linking to the product table and catID linking to the category.

Answer 1

Something like this?

SELECT
  *
FROM
  product
INNER JOIN
  product_category
    ON product_category.productID = product.productID
INNER JOIN
  category
    ON category.catID = product_category.catID