This is the error: Microsoft][ODBC Microsoft Access Driver] ORDER BY clause (ID) conflicts with DISTINCT.
This is the code used: "SELECT DISTINCT Month FROM tbl_LatestNews ORDER BY ID" Table Structure: Month, Headline, Image, Caption, Content I ----- Original Message ----- From: Gurhan Ozen <[EMAIL PROTECTED]> To: Peter Sampson <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 10:14 PM Subject: RE: Simple SQL > Peter, > Please give us more insight on this. Is the column where you store dates (or > months) is a date datatype column?? If yes you can just do > > SELECT ... FROM table_name ORDER BY MONTH(column_name); > > It'll help to see your table structure to help you. > Thanks. > > Gurhan > > -----Original Message----- > From: Peter Sampson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 3:06 PM > To: [EMAIL PROTECTED] > Subject: Simple SQL > > > SQL beginner using Macromedia Ultradev. Can you help? > > Please be gentle I'm not a programmer! > > I am using > > Select DISTINCT Month > FROM tblNews > > The problem is that the months are shown alphabetical not in calendar order. > > How can I change this? > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
