RE: What's wrong with this query?

[Jennifer Goodie]

>what would be causing the error:
>
> 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


I don't think the [CROSS] JOIN gets a join condition. Check the manual on
JOIN syntax
http://www.mysql.com/doc/en/JOIN.html


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]