How to create a query using query builder in Toad for Oracle to join two tables? The data in both of the fields is the same and that they are key fields (Except that one is in uppercase and the other is in lower case.)
ie, t1.f1 = upper(t2.f2).
After trying to create a calculated field in upper case, it throws the error : 'Fields are not of compatible types for a join'
WORKAROUND
None
RESOLUTION
Waiting to be resolved in a future release for Toad for Oracle.
