Use the Join page of the SQLAssist SmartGuide to join tables in an SQL statement. The join page displays the columns of each table selected in the Tables page.
Requesting a join
By default, a join request is assumed to be an inner join. An inner join requests only the rows where the values of the two columns match. You can also request other types of joins by selecting Options. You can select:
Inner join is also an option. You can choose this if want to change a join type from a left or right outer join.
Requesting additional joins
You can request additional joins in the same way as the initial join. You can join other displayed columns in the same tables or in other tables. If you request multiple joins, you can navigate between the joins by selecting > or <. The selected join is indicated by a red join line.
Removing a join
To remove a join, select the joined columns or navigate to the pertinent join. Then select Unjoin. The join line is removed.
When you finish the join
When you finish the join specification, select Next. This displays the Condition 1 page of the SQLAssist SmartGuide. Use this page to specify a search condition for the SQL statement.
When you complete the specification of your SQL statement, select Finish. This generates the code for the SQL statement and closes the SQLAssist SmartGuide.
To cancel the visual composition of the SQL statement, select Cancel.
Specifying the tables for an SQL statement
Specifying search conditions
Specifying result columns
Sorting the result set
Remapping data to a different SQL data type
Displaying the SQL statement