创建视图的SQL语句

求一个创建视图的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