fine true to be
the max.
Henry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 27, 2000 9:28 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: RE: Re(2): [SQL] optimize sql
but active is a boolean field.
[EMAIL PROTECTED] writes:
>I
WHERE code = office_code AND active >= 't'
GROUP BY name
HAVING MIN(active) > 't'
Henry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 9:40 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re(2): [S
[EMAIL PROTECTED] writes:
>How does the output of the above differ from:
>
>SELECT name FROM office, office_application
>WHERE code = office_code
>AND active != 't';
>
>Without knowing the table structures (which tables to active, code,
>and office_code belong to?) it's hard to suggest much els
