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. "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 06:47:44 2006 Subject: RE: How to get these query results Michael, I was under the impression you know what inner and outer joins are? But lets take your SQL Code. SELECT * FROM dates_table, events_table WHERE dates_table.EventID = events_table.EventID This is how the database will see that code SELECT * FROM events_table INNER JOIN Dates_table ON dates_table.eventId = events_table.EventId As for explaining, I think it is ok to make the assumption you know what inner/outer joins are:-) But it seems you don't know what a left or right outer join is then? So with your example it gets translated to a normal inner join, and you have no control. So this is preaching bad sql code in my opinion. Sorry this is way of the topic now, my only point was that when giving example SQL code it is best to give it properly in the first place, and to say won't do it for the sake of doing it is crap, because what you wrote is what I would say is bad practice. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:33 PM To: CF-Talk Subject: RE: How to get these query results > And in this case a left outer join might be better, because the results > might not be what you would normally expect. Andrew, pls explain what you meant by "might not be what you normally expect"? by a simple SELECT * query with a simple cfoutput grouping. And how using joins for this purpose will prevent any unexpected results as you stated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
