If they all share the same PK you could do it all in one query using an inner join (assuming it's a 1:1 Relationship you are after here)
-----Original Message----- From: Ian Littlefair [mailto:[EMAIL PROTECTED] Sent: 26 November 2004 13:38 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:185435 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
