I'm trying to create a view like this:
CREATE VIEW tracks+
(tracks_id, cb,track_num,track_name) AS+
SELECT domtracks_id,bar,track_num,track_name FROM domtracks UNION ALL+
SELECT psvtracks_id,cat,track_num,track_name FROM psvtracks UNION ALL+
SELECT msitracks_id,cat,track_num,track_name FROM msitracks
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?
-David
Songsearch
