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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
