I'm not sure, but I don't think you can do subqueries with QofQ. Try (not tested)
Select * from Query1 where Q1MachineName not in (#QuotedValueList(Query2.Q2MachineName)#) UNION Select * from Query2 where Q2MachineName not in (#QuotedValueList(Query1.Q1MachineName)#) -----Original Message----- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: donderdag 13 maart 2003 15: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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
