View Joins Dialog
From this dialog you can see individual joins, browse through the joins, and make changes to the joins.
| Dialog Section | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| From / To | The join fields, joined from one table to another. | ||||||||
| Join Type | You can change the Join Type from Inner to Outer. The line color denotes the type of join. | ||||||||
| Outer Join On | If you have selected an Outer join, you can change which table the outer join is performed on. | ||||||||
|
Join Test |
You can change the test for the join. You can make it Less than, Greater than, etc. instead of Equal to. | ||||||||
|
Buttons |
|
To open this dialog, click View Joins on the SQL Modeler toolbar. Alternatively, double click on a join line in the Model Area.