Got it, and I understand you're your point, so thanks.
> -----Original Message----- > From: Andrew Scott [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 19, 2006 10:48 PM > To: CF-Talk > 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:253575 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
