>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
I'm beating my head against the wall. I just can't see
what's wrong with it; 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.
> > 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
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
('CP', 'MC', 'AIC', '
Please help me with the following c code:
sprintf(update, "update chrc set center='");
len = 24;
memcpy(update+len, center, 128);
len += 128;
sprintf(update+len, "', var='");
len += 8;
m
Hi all,
I've tried to create the following type of field in a table:
create table temp(id float(100,50) unsigned);
insert into temp
values(123.1234567890123456789012345678901234567890123456789012345);
select * from temp;
This prints:
123.12345886230469
What's wrong with MySQL?