Report Query - Managing Table Joins

Choose the method with which you would like to set up the join between the tables. You can choose to do a more standard field join or you can type in the custom text that you would like to use to join the tables.

Joins can be added to the Data Dictionary using the Contribute button.

This image is the Join Type dialog with two options. You can join a field in one table with a field in another, or join one or two tables by text.

Single Field Join

This image is the Edit Join dialog where you can specify table joins. Options include Inner Join, Outer Left Join, and Outer Right Join.

Select the table names and field names you would like to include in the join. Then select the join type; inner, outer left, or outer right.

Custom Text Join

You will need to select a text join if you are joining tables on more than one field or if there is a where clause involved.

This image shows the Edit Join dialog where you can perform a Custom Text Join. A free-form work area exists where you can specify more complex joins.

If you need to place your text condition as part of the FROM, then you should select JOIN Clause from the Location drop-down. Please note that the Location drop-down will be disabled until both a left and right table are supplied for a join.

This image shows the Edit Join dialog where you can perform a Custom Text Join. A free-form work area exists where you can specify more complex joins.

Need More Help?

If you need additional help creating DataBlocks, refer to the Getting Started with DataBlocks page.