what SQL have you already?
you may have to alias the table or the field to include it twice in the query. cheers barry.b -----Original Message----- From: Gareth [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 September 2003 9:30 AM To: CFAussie Mailing List Subject: [cfaussie] SQL or Coldfusion? I am writing a forum, in one table I have my topics and the replies to those topics. I wish to be able to sort by the 'last post' which is the 'added' field in my topics table. This at first seems simple. But where I wish to sort it is where the topic headers are listed. Basically I need to join the 'topics' table to itself, which I have done but then I need to ask the join to return the entry with the latest date (maybe some sort of order?), at the moment it returns the first entry that it can find, so if there is only one reply to a topic it works perfectly, but this is a forum so there is no chance of that happening. Hopefully someone can help me out. Cheers Gareth Edwards. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
