I believe both work. But the syntax diagram shows WHERE before ORDER and I have never had a reason to do otherwise.
Bill Cook Kent WA USA ----- Original Message ----- From: "Stephen Markson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 10, 2002 6:40 AM Subject: RE: Sequencing the Where & the Sort statements > 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/ ================================================ 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/
