我这个MySQL怎么报错

Question

SELECT p.* FROM product AS p , product_product_category AS c WHERE p.deleting = 0 AND ( p.product_category_id IN ( 1, 2 ) OR (p.product_id = c.product_id AND c.product_category_id IN ( 1, 2 ) )

两个表用 product_id 关联
如果 product 表没有 product_category_id 就去 product_category 找

Answer 1

你没发现你贴上来的括号不成对儿么？左括号有 6 个，右括号只有 5 个。