sql里 创建一个视图 里面包含2个表 语句怎么写?
1个回答
展开全部
不知改禅道你核模尘具体是什么库,提供05的方式码碧
create
view
v_test
as
select
row_number()
over(order
by
id)
as
id
,a.name,a.id
as
di
from
(
select
*
from
dbo.表1
union
all
select
*
from
dbo.表2
)
as
a
create
view
v_test
as
select
row_number()
over(order
by
id)
as
id
,a.name,a.id
as
di
from
(
select
*
from
dbo.表1
union
all
select
*
from
dbo.表2
)
as
a
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
