>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
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
> > Why isn't the key being used in the "c" (certificate) table?
> > SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname
> > FROM master_info a, logins lsl, logins lc, certificate c WHERE
> > a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid AND
> > c.void <> 1 AND c.status IN
>
On 19 Jun 2003 at 16:18, Chris Boget wrote:
> Why isn't the key being used in the "c" (certificate) table?
>
> SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname
> FROM master_info a, logins lsl, logins lc, certificate c WHERE
> a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid