Hi Guys Anyone know of any easy way to query 3 different tables, but outputting the results of a search as one single record set ? I have tried unions, running 3 seperate select statements inside the one <cfquery>, the tables are quite different in structure so the union doesnt want to play.. There is no relational aspects between the tables so a join wont work either.
Is there a way to run 3 seperate queries and then combine the results into a single collection for output? I want to do the next/previous across the search results page also hence the complexity.. Any ideas or thoughts appreciated.. Jason --- 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/
