Creating joins in the SQL Query Builder
If you select multiple columns in two or more tables in an SQL statement, you need to specify how the rows of these columns are associated in the join of the tables. You can use the SQL Query Builder to define the join conditions.
Before you begin
SQL support for joins in the SQL Query Builder is dependent on the level of support that is provided by IMS™. If you use the SQL Query Builder to create joins, the tool attempts to create the correct syntax for IMS.
The SELECT statement must be open in the SQL Query Builder, with two or more tables specified in the Tables pane.
Only related segments within the same hierarchical path can be joined.
Procedure
To create a join in the SQL Query Builder:
Create a join by dragging or by using a pop-up menu:
Method for creating a join | Procedure |
---|---|
To create a join by dragging |
|
To create a join by using a pop-up menu |
|