Not sure if this ever made it to the group, I can't seem to find it in the recent message lists.
"speakeasy" <[EMAIL PROTECTED]> wrote in message news:... > 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. > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
