Hi Jason, you could try setting up a view or more likely a stored procedure that could hand it back to you the way you want it? Personally I'd go with a stored proc...
Friday, March 21, 2003, 1:26:25 PM, you wrote: m> Hi Guys m> Anyone know of any easy way to query 3 different tables, but outputting the m> results of a search as one single record set ? m> I have tried unions, running 3 seperate select statements inside the one m> <cfquery>, the tables are quite different in structure so the union doesnt m> want to play.. There is no relational aspects between the tables so a join m> wont work either. m> Is there a way to run 3 seperate queries and then combine the results into a m> single collection for output? I want to do the next/previous across the m> search results page also hence the complexity.. m> Any ideas or thoughts appreciated.. m> Jason m> --- m> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] m> To unsubscribe send a blank email to [EMAIL PROTECTED] m> MX Downunder AsiaPac DevCon - http://mxdu.com/ --------------------------------------- Life is poetry - write it in your own words. --------------------------------------- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
