Toad World® Forums

Have limit in the "where" clause on an, outer joined, table be part of the join clause and not the global where clause


#1

At this moment the query Builder will put where clauses, entered into the diagram, in the global where clause. The problem is that these limits will then revert any outer joins into inner joins. 

It would be useful if where clauses on fields from tables in an outer join be part of the join clause (in case of the ANSI join) or get a "(+)" notation (in case of non-ANSI join)