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.
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.
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.
You can join a column in a table with a column of an alias. An alias is an alternate name for a table. Joining a column to an alias gives you a way of joining two columns in the same table. You can do this as follows:
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 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.
Select Back to display the Tables page of the SQLAssist SmartGuide. If appropriate, you can then change the tables selected for the query.
You can also display any page in the SQL Assist SmartGuide by selecting its tab.
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.