You use this option to define a simple source query. You can use this query to define an import source that combines various tables belonging to a selected source database or various files of the same type (.txt, .csv, and so forth). You select any number of tables in the selected source database and then define the relationships between selected tables. You can then use the defined query when creating a link. You use the Source Query Wizard to define a source query.
-
Do one of the following:
-
Click File > New > Query.
-
Right-click the Queries folder and then click New Query on the shortcut menu.
-
-
In the Source Query Wizard, on the Define the Query Name and Description page, under Query, type the query name.
-
Under Description, type a brief description of the query if needed.
-
Click Next.
-
On the Select the Source Tables page, from the Source tables list, select a table and click
to move it to the Selected tables list.
You can click 
to select and move all the source tables to the Selected tables list.
-
Click Next.
-
On the Define the Relationships Between Tables page, click Add.
-
To define the relationships between the tables, from the Left Table and Right Table lists, select the tables that you want to join.
-
From the Left Column and Right Column lists, select the columns that correspond to common or compatible data in both left and right tables.
-
Click Add to define another relationship or click Next.
-
On the Completing the Source Query Wizard - Query Results page, examine the query results and click Finish when done.