Toad World® Forums

TDP 5.0 Workbook Outer Join

Using TDP Workbook, trying to create an outer join as shown in the screen shot below. Couldn't figure out how to create this join in Diagram tab but was able to enter the SQL manually in Query tab. When I execute the query it runs correctly but I'm getting an error when trying to synchronize query and diagram. Also I cannot save the workbook since the query and diagram are not synced.

Hi Steve,
In Query Builder you connect columns with an arrow.

In the middle of the arrow you can see an inner join icon - if you right-click you can select right or left outer join by selecting all columns from either of the tables.
The left side is where the arrow is starting and the right side is the end of the arrow.
Currently, the order of the tables in the Venn Diagram window does not respect the order in this relation.

More details are in the Help topic - Join Columns and Analyze Joins
Does it answer your question?

My question is about a complex join where there is an additional limit besides the outer join between the 2 tables. In the screen shot I sent in the initial post, there is an outer join between VEND.VEND_ID and VEND_ADDR.VEND_ID but also an additional limit that needs to be part of the outer join: VEND_ADDR.S_PMT_ADDR_CD='Y'. In reading some other posts on this subject, I tried creating a calculated field VEND.S_PMT_ADDR_CD and setting it equal to 'Y' and then joining it to VEND_ADDR.S_PMT_ADDR_CD and that seems to work. Is that the recommended way to implement the complex outer join?

Hi Steve,
yes, since that is really unsupported in Query Builder, using calculated fields is the recommended way.
Could you add your suggestion to idea pond where the product management might decide about possible improvements?