求一个创建视图的SQL语句用两个表（表结构一样）做成的视图，想要修改其中一列的列名，再加一列（列名用前面那个）并把这一列的记录都赋值为a。怎么写？[解决办法]Create View V_TEST As Select A, B, C, D As E, 'a ' As D From A Union All Select A, B, C, D As E, 'a ' As D From B GO
