Yeah could be crossing, but it is this syntact which is non-standard and should be avoided.
"SELECT * FROM dates_table, events_table" Where the INNER JOIN syntax is substituted with a comma. -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 20 September 2006 12:54 To: CF-Talk Subject: RE: How to get these query results Hi, Neil...I think out conversations are crossing...(reminds me of why I hated chat rooms... :oP) Anyway, the code I was referring to was in the original post, not any post referencing joins... <cfquery name="your_query"> SELECT * FROM dates_table, events_table WHERE dates_table.EventID = events_table.EventID </cfquery> I guess from what Andrew was saying, it would skip a step that would be necessary by an SQL server to translate it into a join? But, my question concerning it being "bad code" was, really, how much slower for probably a small amount of data would this code be? (And I was wondering, too, why there would even be a separate "dates" table in a relational database...if this is a calendar, I would have put the dates of an event in the event table itself...???) Rick -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 7:39 AM To: CF-Talk Subject: RE: How to get these query results As noted, it is non-standard. -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 20 September 2006 12:32 To: CF-Talk Subject: RE: How to get these query results Why is it bad code? Is it slower to process? Rick -----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:03 AM To: CF-Talk Subject: RE: How to get these query results Michael, You really need to learn inner joins, sorry but that is bad sql code without it. 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 2:55 PM To: CF-Talk Subject: RE: How to get these query results <cfquery name="your_query"> SELECT * FROM dates_table, events_table WHERE dates_table.EventID = events_table.EventID </cfquery> <cfoutput query="your_query" group="EventID"> #EventName#<br> <cfoutput group="EventDate"> #EventDate#<br> </cfoutput> <br> <br> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
