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 ( <list_of_column_names> )
versus
ON <expression>
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]
