JOIN Issues

[rseigel]

SELECT * FROM ps_product_supplier JOIN ps_product JOIN ps_product_attribute USING (id_product) WHERE ps_product.active = '1' AND ps_product.ean13 = '' AND ps_product_attribute.ean13 = '' AND ps_product.id_category_default != '73'

This doesn't work (no surprise from those with way more experience here than me).

 

The common column between the 3 tables is id_product.

 

I know everything past the WHERE works. Things went sideways when I introduced the 2nd join (ps_product_attribute).

 

Please help..... 

[Barand]

You need to specify the join condition for each join

SELECT * 
FROM ps_product_supplier 
    JOIN 
    ps_product USING (id_product)
    JOIN 
    ps_product_attribute USING (id_product) 
WHERE ps_product.active = '1' 
    AND ps_product.ean13 = '' 
    AND ps_product_attribute.ean13 = '' 
    AND ps_product.id_category_default != '73'

[rseigel]

Thanks very much. That works.

 

I have other issues with the code (trying to grab the right fields among all the tables) but what you did makes perfect sense.