In these steps you start a query on the Products data,
and then you add the Categories data.
In
the project tree, click Products to make it the
active data set. Select TasksData
Query Builder.
In
the Query Builder window, click Add Tables. In
the Open Data window, click Project.
Double-click WORK.CATEGORIES.
Click to view the full window.
When
you add the Categories data, the tables are automatically joined
on the common column CategoryID. In the Query Builder window, click Join Tables. If the join order is not displayed at the bottom of the window, you can click Join Order to display it.
The two tables are represented in the Tables and Joins window. The
symbol between the tables tells you what kind of join it is. The
default join type is matching rows only, which is also called an inner
join. The output rows include those for which the column in
the first table matches the joining criterion of the column in the
second table.
You can modify the type of join by right-clicking the join symbol and selecting Properties from the pop-up menu.
Data