I can't say that I've ever had to try a sub-select in a QoQ but I have used this for combining queries and works well.
http://www.cflib.org/udf.cfm?ID=1021 -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 9:48 AM To: CF-Talk Subject: Subqueries in query of queries? I'm trying to make a data import script that I am writing more efficient be combining 2 query of queries (from 2 separate queries) into one. Unfortunately, I can't get it to work. Does query of queries in MX7 support subqueries (AKA subselects)? Thanks Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217212 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
