在线等，谁会阿？！！帮忙！

[bushcong]

我有三个表：a , b ,c ；
现在要创建一个视图，把上述三表中各自的ID和Name列提取出来
并在视图中增加一列“来源ID”
把来自表a的那些项的来源ID那一栏置为1，
把来自表b的那些项的来源ID那一栏置为2，
把来自表c的那些项的来源ID那一栏置为3，
视图出来的实例应该是：
ID Name S_ID
====================
01 aa1 01
02 aa2 01
01 bb1 02
01 cc1 03
大虾们谁会创建这个视图啊？？？小生感激不尽阿！！！

[九斤半]

union all

[九斤半]

select id,name,S_ID='01' from a
union all
select id,name,S_ID='02' from b
union all
select id,name,S_ID='03' from c

[i9988]

create view v_abc
as
select id,name,'01' as s_id
from a
union all
select id,name,'02' as s_id
from b
union all
select id,name,'03' as s_id
from c

go

[fcuandy]

create view v
as
select id,name,frm=1 from tbA
union all
select id,name,frm=2 from tbB
union all
select id,name,frm=3 from tbC

[playwarcraft]

create view view_name
as
select A.id,A.name,'01' as S_id from A
union
select B.id,B.name,'02' from B
union
select C.id,C.name,'03' from C

[fcuandy]

这种东西我这文章里都有讲了.

http://community.csdn.net/Expert/topic/4930/4930477.xml?temp=.7780268

[playwarcraft]

我暈...誰誰說不搶分的來着...

[bushcong]

大家好热情啊，谢谢谢谢！！！！！！！
还有，就是我刚才创建了那个视图，但是视图的三列的那个名字不对
我本来想要的结果是：ID Name S_ID
但因为表A里面是SYS_ID和SYS_name
现在出来的视图里面的三列是SYS_ID SYS_name S_ID
这个怎么改成ID Name和S_ID阿？？

[九斤半]

LZ这个帖我不要分了，不要给我分~~~

select SYS_ID as id,SYS_name as name,S_ID='01' from a
union all
select SYS_ID as id,SYS_name as name,S_ID='02' from b
union all
select SYS_ID as id,SYS_name as name,S_ID='03' from c