Re: Problema with left join
[EMAIL PROTECTED] wrote: Hi, I resolve my problem... select count(p.products_id) as total from products_description pd, products p left join manufacturers m using (manufacturers_id), products_to_categories p2c left join specials s using (products_id) where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id = '16' Read: http://dev.mysql.com/doc/refman/5.0/en/join.html especially the part starting with: "Before MySQL 5.0.12, the comma operator (,) and JOIN both had the same precedence (...)". It may be wiser to replace the comma-operator by an explicit JOIN to prevent any problems with precedence, using aliases before they are declared, etc. This part of the manual explains the changes made in MySQL regarding the handling of joins in MySQL 5. Regards, Jigal. smime.p7s Description: S/MIME Cryptographic Signature
Re: Problema with left join
Hi, I resolve my problem... select count(p.products_id) as total from products_description pd, products p left join manufacturers m using (manufacturers_id), products_to_categories p2c left join specials s using (products_id) where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id = '16' that`s ok :) Thanks Em 16/12/2005, às 11:40, Jigal van Hemert escreveu: [EMAIL PROTECTED] wrote: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.manufacturers_id = m.manufacturers_id ) LEFT JOIN specials s USING ( p.produc' at line 4 What's the error in the query?!!? USING ( ) versus ON AFAIK it would be: USING (products_id) or ON p.products_id = s.products_id etc. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problema with left join
[EMAIL PROTECTED] wrote: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.manufacturers_id = m.manufacturers_id ) LEFT JOIN specials s USING ( p.produc' at line 4 What's the error in the query?!!? USING ( ) versus ON AFAIK it would be: USING (products_id) or ON p.products_id = s.products_id etc. Regards, Jigal. smime.p7s Description: S/MIME Cryptographic Signature