Select * from Table1 Inner join Table2 on table1.EventId = table2.eventId You might need a left or right outer join though
Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 2:35 PM To: CF-Talk Subject: How to get these query results So I have 2 tables. Example data and desire results below. EventID, EventName 1 | TestEventOne 2 | TestEventTwo EventID | EventDates 1 | 9/10/2006 1 | 9/20/2006 2 | 9/15/2006 <!--- Desired results ---> TestEventOne 9/20/2006 9/10/2006 TestEventTwo 9/15/2006 So basically I want to order by date, but group by the EventID. Ordering by date breaks the ability to group by EventID. I know I could do this by running a query as I do the output (even a QofQ), but was hoping to somehow get the results back in a way to output in this manner. Ideas are much appreciated. -- Matt Williams "It's the question that drives us." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
