Re: Simple Count Query

2005-09-09 Thread Rhino
--- 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

Re: Simple Count Query

2005-09-09 Thread Rhino
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