Return
-
Title
Query Builder error "Fields are not of compatible types for a join" -
Description
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'
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.