SQL 我现在要创建一个视图，有一列的字段值来自多个表，如图所示，这个语句该怎么写，谢谢
展开全部
不知道你具体是什么库,提供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
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
