Rob, Not sure if CF5 query of queries can handling your sub-selects. Anyway, try this as a possible alternative:
Select * from Query1 where Q1MachineName not in (#QuotedValueList(Query2.Q2MachineName)#) UNION Select * from Query2 where Q2MachineName not in (#QuotedValueList(Query1.Q1MachineName)#) Thanks, Andr� -----Original Message----- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: 13 March 2003 14:37 To: CF-Talk Subject: Query of Queries w/ subquery in CF 5? I am using ColdFusion 5 Enterprise Edition. I have 2 separate oracle databases that cannot communicate to each other, but the web server can communicate to them individually. I am pulling back data from to queries as such. Query 1: Machine1 null Loc1 Machine2 null Loc2 Machine3 null Loc3 Machine4 null Loc4 Query2 null Machine1 Loc1 null Machine3 Loc3 null Machine4 Loc4 null Machine5 Loc5 I am trying to get a union query with nested selects to work as such Select * from Query1 where Q1MachineName not in (Select Q2MachineName from Query2) UNION Select * from Query2 where Q2MachineName not in (Select Q1MachineName from Query1) So I end up with Machine2 null Loc2 null Machine5 Loc5 The problem is, when I run the union query above, I get the error Query Manipulation Error Code = 0 Can't find symbol: select Any suggestions as to what I am doing wrong? Thanks, Rob Edwards ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
