Hi Bill, Like me, there's never been any reason to do otherwise - I only tried my command just to prove to myself that it made no difference and ended up with a difference.
Looks like I need to investigate further... I can only think at the moment that it has something to do with selecting the last 100 rows in the table for some reason. Regards, Alastair. ----- Original Message ----- From: "William Cook" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 10, 2002 5:31 PM Subject: Re: Sequencing the Where & the Sort statements > 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/ ================================================ 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/
