We are moving away from Hyperion Brio to TDP for some reports. The way that Brio worked was that, when putting a limit/filter in a field from a table that had an outer connection to the rest of the statement, the outer join would be taken into account (only apply filter if there is a field to be sel…

That looks like an error in Toad or you are adding () when Toad is about to do it for you. General rule is if you add a field from an outer join in the where clause you turn it into an inner join. You can make your outer join a complex join and put the condition from the where clause into the join…

Thanks for the answers. -So the adding “()” when not warranted seems to be a Toad bug or a limitation/consequence of the visualization algorithm. It seems to also copy the Joins into the “global Where clause” sometimes resulting in several copies of the join clauses when using several visualizatio…

I realize this is an older thread - but our company is doing the same transition and I am having issues making the outer join, even with creating a calculated field. This also does not work for me - I only get records that have never had a matching item in table 2. Otherwise you have to change the…

Hi Elle! Please see this topic about Joins in Query Builder - is that what you were looking for? [image] TDP 5.0 Workbook Outer Join Toad Data Point 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 c…

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

Toad Data Point & Toad Intelligence Central

dan June 13, 2019, 11:34am 5

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

Topic		Replies	Views
Left join becomes inner join when where clauses are added Toad Data Point & Toad Intelligence Central	8	5150	June 16, 2017
TDP 5.0 Workbook Outer Join Toad Data Point & Toad Intelligence Central	5	1749	June 20, 2019
Webinar Help - Tell us your top questions about Toad Data Point Visual Query Builder Toad Data Point & Toad Intelligence Central	6	1066	August 30, 2023
left outer join in query builder Toad Data Point & Toad Intelligence Central	1	1268	April 3, 2011
Query builder - editing SQL code breaks query Toad Data Point & Toad Intelligence Central	1	679	July 1, 2021

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

Related topics