You will need two of
the sample tables to practice using the examples in this section.
If there is an active
query in the SQL Query Window, then select
ToolsReset to
clear the query. Select
OK in the dialog
box that appears.
In the
SQL
QUERY TABLES window, select
SAMPLE.EMPINFO and
SAMPLE.SALARY from the Available Tables
list and add them to the Selected Tables list.
Select
OK to display the
SQL QUERY COLUMNS window.
Add
Identification Number,
DIVISION,
Education level, and
Salary to the Selected Columns list.
Select
ViewJoin Type. Select
Matched Join from
the
Join Types window to create an inner
join. Select
OK.
Select
Identification
Number from both lists in the
Columns for
Setting Join Criteria window.