Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Fri, Jan 5 2007 6:26 PM	Permanent Link
"Carlos"	select inv.date INVDATE, count(distinct inv.clientNum) NUMOFCLI from invoice inv group by invoice.date Can this be done on DBISAM Ver3 arlos
Mon, Jan 8 2007 4:29 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Carlos, << select inv.date INVDATE, count(distinct inv.clientNum) NUMOFCLI from invoice inv group by invoice.date Can this be done on DBISAM Ver3 >> No, DISTINCT is not supported in the COUNT() statement. -- Tim Young Elevate Software www.elevatesoft.com