If you have 6 queries all returning data from the same database, and you need a result that is obtained by working with multiple queries, then this almost definitely needs to be done at the database level using joins or stored procedures.
--- Ben -----Original Message----- From: Ian Littlefair [mailto:[EMAIL PROTECTED] Sent: Friday, November 26, 2004 8:38 AM To: CF-Talk Subject: Multiple Queries - Is this possible? I have six queries all using the same database and based on order_number. Is there a way that if an order_number appears in query1 and query2 I can show the order_number in query2 output only and not also in query1 and so on with all the six queries. TIA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185437 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
