Hi,
I have a scenario where i want to select data from multiple tables on source database. I created a replicat process which uses a SQLEXEC command with query joining multiple tables from source database. Replicat process got abendened and error logs described "Table or view does not exist". The error is obvious that those tables reside on source db not on target. How do i proceed and get data replicated on target db from join of tables in source db. Please help.