Re: Ordering by grouping

2011-04-09 Thread S�ndor Hal�sz
2011/04/08 17:12 -0400, Michael Dykman Mildly surprised this is working at all. Your name alias fields like "When" should be quoted by back-tics, no double quotes.. this is a clarification and does not solve the issue really although it might make your final result less surprising. A

Re: Ordering by grouping

2011-04-08 Thread Michael Dykman
Mildly surprised this is working at all. Your name alias fields like "When" should be quoted by back-tics, no double quotes.. this is a clarification and does not solve the issue really although it might make your final result less surprising. A key thing to note about GROUP BY is that, althoug

Ordering by grouping

2011-04-08 Thread hsv
Once more I am surprised by the ordering that I get from 'GROUP BY'. This defines the table of directors that have been on the board: CREATE TABLE DIRECTOR ( Chosen DATE NOT NULL , Through DATE NOT NULL , MemberIDINTEGER REFERENCES MemberAddress (MemberID) , CONST