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:253568
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
