David, The first SELECT sets the datatypes. For the subsequent SELECTS, put cat in parentheses so that it is an expression (not a column), and R:Base will convert it to text(11) internally for you.
Bill >Essentially I'm trying to make bar in the same column as cat. BAR is >TEXT(11) and CAT is TEXT(7) . When I try to run this, i get: > >-ERROR- Column type mismatch in UNION (2372) > >I know the problem is with the lining up of bar and cat because i took out >these two columns in the select statements and the view was created >successfully. However, I need that information in there. If it's >impossible to put two different text sizes in the same column, I'll settle >for putting bar and cat in different columns in the view. But psvtracks >and msitracks both don't have a BAR column, and domtracks does not have a >CAT column. > >Any suggestions?
