Neil, Actually looking at the data output required I would say a right outer join is required here and then the order by will work as required.
So that the SQL shoulq be SELECT * FROM events_table RIGHT OUTER JOIN dates_table ON events_table.EventID = dates_table.EventID Order by events_table.EventId <cfoutput query="query" group="EventId"> </cfoutput> Which will give you EventName1 - EventDate EventName2 - EventDate Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:59 PM To: CF-Talk Subject: Re: How to get these query results You would not need any kind on outer join left or otherwise if the relationship is inner. I agree that the comma seperated inner join syntax is newb but the main reason you shouldn't use it is that it is n non-standard and could deprecated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253574 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
