I thought the GROUP BY comes before the WHERE. It works in RBase. Regards,
Stephen Markson ForenSys The Forensic Systems Group www.ForensicSystemsGroup.com 416 482 2140 > > Correct syntax for SQL statements (most languages) is SELECT ... FROM ... > WHERE ... [Group by] ... ORDER BY > ================================================ 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/
