In the Query Builder, trying to do a JOIN from a calculated field (e.g. SUBSTR, AVG, etc.) to another table column of the same data type gave the error:
"Fields are not of compatible types for a join."
WORKAROUND:
1. Create a simple JOIN with normal columns, or non-calculated columns.
2. Use the generated query as template.
3. Insert the name of the calculated filed column into the query.
STATUS:
Enhancement request ST65766 has been submitted to Development for consideration in a future release of Toad for Oracle.
