2 questions Query Builder: filter on filed in left outer join in diagram , Visualize Query: curb the amounts of "()" added.

[dan]

Hi Elle!
Please see this topic about Joins in Query Builder - is that what you were looking for?

TDP 5.0 Workbook Outer Join

Using TDP Workbook 5.0.4.45, 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. [outer%20join]