Bruce Sorge wrote: > DB21034E The command was processed as an SQL statement because it was not a > valid Command Line Processor command. During SQL processing it returned: > SQL0204N "ADMINISTRATOR.TBLDONE" is an undefined name. SQLSTATE=42704 > > SQL0204N "ADMINISTRATOR.TBLDONE" is an undefined name. > > the table does exist and is under the schema ADMINISTRATOR.
Does the select without the insert work? What if you alias the tables? Do you really need the full outer join? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2838 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
