I tried doing a SELECT...UNION to read data from table_1 (in the current app.) and table_2 (table in a different folder), but it's not working. So I tried doing a query on table_2 (w/ a different session) and then appending it to a temp. table (w/ TBatchMove) in the current app., but I am getting an EDBEngineError:'Attemp to mix objects from different Sessions'.
Note: The current's app. tables are using the default session and table_2 is accessed using a different session.
Any ideas/suggestions would be appreciated.