Re: Problema with left join

[Jigal van Hemert]

[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.

smime.p7s
Description: S/MIME Cryptographic Signature