I have two databases, A and B.
A is a read-only table.
I'm wondering if it's possible to run an "insert into select" query on Table B.
insert into B:data (B:data.test)
select A:data.test from A:data
where A:data.test = '0';
Will A be able to do this? I'd just check myself but I'm running these queries through VMS using Attunity and the error messages are archaic.