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…

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

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
Have limit in the "where" clause on an, outer joined, table be part of the join clause and not the global where clause Idea Pond	0	823	May 23, 2018
Webinar Help - Tell us your top questions about Toad Data Point Visual Query Builder Toad Data Point & Toad Intelligence Central	6	1041	August 30, 2023
Table Filter Comments Toad for Oracle & DevOps Toolkit	1	1212	October 9, 2015
Query builder - editing SQL code breaks query Toad Data Point & Toad Intelligence Central	1	661	July 1, 2021
left outer join in query builder Toad Data Point & Toad Intelligence Central	1	1231	April 3, 2011