Correct syntax for SQL statements (most languages) is SELECT ... FROM ... WHERE ... [Group by] ... ORDER BY
There are some odd exceptions, such as SyBase that has its own syntax rules, but db2, rbase, access and sqlserver use the sequence above "Alastair Burr" <[EMAIL PROTECTED]> wrote: >Hello all, > >I have always believed that it made no difference whether you wrote a >command as: > >select �... �from ... where ... order by ... > >or as: > >select �... �from ... order by ... where ... > >However, I have a report where it does appear to matter. > >If I use: > >PRINT Last100_HTML + >WHERE COUNT > .vCount + >ORDER BY MainName, FirstName, ReleaseSequence > >the sort that is applied appears to be by FirstName then MainName then >ReleaseSequence! However, if I write the command as: > >PRINT Last100_HTML + >ORDER BY MainName, FirstName, ReleaseSequence + >WHERE COUNT > .vCount > >then the sort works as expected. There are no break points defined on the >report. > >Is this something that has changed over the years and I simply haven't >noticed or is it to do with the way that data is selected when compared to >the count (or any other?) function? > >Thanks for any enlightenment, >Regards, >Alastair. > >---------------------------------- >A D B Burr, >St. Albans, UK. >---------------------------------- >[EMAIL PROTECTED] >---------------------------------- > >================================================ >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/ > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
