I have a field defined as a character(50) data type, and the same field
stored in a transition table as a text type.
The view itself work based on the join, however sub-queries against the view
on that field do not return any data.
Example:
Table1
----
T1Data - Character(50)
Table2
----
T2Data - Text
View1:
---
SELECT T1Data from Table1 JOIN Table2 ON (Table1.T1Data = Table2.T2Data);
A select against View1
SELECT * FROM View1 returns all relevant records, however, adding a WHERE
clause produces no output.
Please advise.