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> HTH(?) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
