Bernie, Try this:
sel count(distinct salesorderno) from salesorderdetail It worked for me. Richard (Ringo) Starkey -------Original Message------- From: [EMAIL PROTECTED] Date: Thursday, September 05, 2002 3:51:04 PM To: [EMAIL PROTECTED] Subject: count 6.5++ sel count(distinct(orderno)) from mlitmln gives error col count not found sel distinct(count(orderno)) from mlitmln ignores the distinct and just counts all the rows. so how can I count the number of orders in this table? (the same orderno can occur many times) Bernie Lis Megabytes, Inc. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
