Creating join

The join conditions can be generated automatically by OZ Query Designer or you can configure the join conditions by yourself.

Creating join conditions automatically

When the "Detect join condition automatically" option in Options dialog ([File] > [Options] > [database] > [General]) was checked, and if the added tables can have join condition, then the join conditions are created automatically.

Note

For the case of a database, like Oracle or Ms-SQL, that is allowed to get the Primary and Foreign Key combination via JDBC functions, if fields of two table are connected by Primary or Foreign Key, the join condition will be created automatically.

Although a database is not allowed to get the Primary and Foreign Key combination via JDBC functions, if fields of two table have the same name and same type, the join condition will also be created automatically.

Creating join conditions manually

To create join conditions manually, connect from the source table field to target table field by dragging. If select and double click the join connection line, or select [Join Type] from the right mouse click popup menu on the join connection line, Join Type dialog will appears.

You can change the type of join using the Join Type dialog. Join Operator can be set to "=", "<", "<=", ">", ">=", "<>". Join Type can be set to "Inner Join", "Left Outer Join", "Right Outer Join", "Full Outer Join".

Deleting join conditions

To delete join conditions, select the join connection line and push <delete> key, or select [Delete Join] from the right mouse click popup menu on the join connection line.

Note

Option dialog appears by selecting [File] > [Option] in the menubar. And the user can find out whether the "Detect join condition automatically" option is enabled or not by checking [Database] > [General] tab of option dialog.