Andrew, The sql with cfoutput I sent Matt would do what he needed, as he stated- period. I know how to do inner/outer joins, but wont do it just for the sake of doing it. But thanks for your good advise. Michael
> -----Original Message----- > From: Andrew Scott [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 19, 2006 10:03 PM > 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> > > 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:253562 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
