Writing an SQL Query by Joining Multiple Source Tables and Migrating to a Single Target Table

In the SQLWays Wizard tool we can migrate a query that will join several tables and import into one target table.

To perform this action, we should click on “Specify Objects” dropdown list and select “Use Query” item on the “Objects Selection” page.

In the opened window click on the “Add query” button and specify the query or several queries.

Make sure that query will return columns with non-duplicate names so that the target table can be created in the target database.

Then continue the conversion process as usual.

If you have any questions or face any difficulties, please contact our support team at support@ispirer.com