On 10 Jul 2003 at 13:20, Chris Boget wrote:
> SELECT certificate.cert_num, master_info.uid
> FROM certificate
> JOIN master_info ON ( certificate.uid = master_info.uid )
> LEFT JOIN endorsements ON ( certificate.cert_num =
> endorsements.cert_num ) WHERE certificate.active = 1 AND
> certificate.referred = 0 AND certificate.status IN ('O', 'C') AND
> endorsements.endorse_mode='cancel' ORDER BY master_info.company,
> certificate.bound, certificate.cert_num;
>
> ERROR 1064: You have an error in your SQL syntax near 'ON (
> certificate.uid = master_info.uid ) LEFT JOIN endorsements ON (
> certificate' at line 1
Plain "JOIN" doesn't take a join condition (ON). You presumably mean
"INNER JOIN". See the documentation:
http://www.mysql.com/doc/en/JOIN.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
