SQL 我现在要创建一个视图，有一列的字段值来自多个表，如图所示，这个语句该怎么写，谢谢

Question

如题所述

Answer 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

Answer 2

两个表Union就可以了