--- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Ed Reed" <[EMAIL PROTECTED]>;
Sent: Friday, September 09, 2005 6:26 PM
Subject: Re: Simple Count Query
> I think you want this or something similar:
>
> select count(distinct fld2)
> from yourtab
I think you want this or something similar:
select count(distinct fld2)
from yourtable
where fld4 = 'am';
N.B. I have not tested this solution.
Rhino
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 09, 2005 6:08 PM
Subject: Simple Count Query
I