I didn't even look at the problem as everyone had already noted an inner join hence why I noted "if" the relationship is inner.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Andrew Scott To: CF-Talk Sent: Wed Sep 20 07:06:51 2006 Subject: RE: How to get these query results 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:253576 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
