创建多表关联的视图问题

[笨狗熊]

如下语句对3个表进行查询，记录保存在一个结果集中：
select MOBILE,CERTID,GROUPID,'0' as TERMTYPE from carterm
union all select MOBILE,USERNAME,GROUPID,'1' as TERMTYPE from mobileterm
union all select MOBILE,USERNAME,GROUPID,'2' as TERMTYPE from handsetterm
结果集部分数据如下：
MOBILE CERTID GROUPID TERMTYPE
12345 湘-123 010200 0
... ... ... ...
求教写一个视图，对视图查询就可实现上面SQL语句的功能！

[liangCK]

CREATE VIEW v_test
AS
    select MOBILE,CERTID,GROUPID,'0' as TERMTYPE from carterm
union all select MOBILE,USERNAME,GROUPID,'1' as TERMTYPE from mobileterm 
union all select MOBILE,USERNAME,GROUPID,'2' as TERMTYPE from handsetterm 
go

SELECT * FROM v_test

[JonasFeng]

楼上的正解

[贾桂权]

Create view V_term
as
select MOBILE,CERTID,GROUPID,'0' as TERMTYPE from carterm
union all select MOBILE,USERNAME,GROUPID,'1' as TERMTYPE from mobileterm 
union all select MOBILE,USERNAME,GROUPID,'2' as TERMTYPE from handsetterm 
GO

--调用
select * from v_term

[csdyyr]

create view view_name
as
select MOBILE,CERTID,GROUPID,'0' as TERMTYPE from carterm
union all select MOBILE,USERNAME,GROUPID,'1' as TERMTYPE from mobileterm 
union all select MOBILE,USERNAME,GROUPID,'2' as TERMTYPE from handsetterm 

[笨狗熊]

谢谢各位！

[ws_hgo]

create view V_Info
as
 select MOBILE,CERTID,GROUPID,'0' as TERMTYPE from carterm 
union all
 select MOBILE,USERNAME,GROUPID,'1' as TERMTYPE from mobileterm  
union all
 select MOBILE,USERNAME,GROUPID,'2' as TERMTYPE from handsetterm