用存储过程可以吗? 视图中有很多限制create table view1 ( id1 int, name1 varchar(10) ) gocreate table view2 ( id2 int, name2 varchar(10) ) goinsert into view1 values(1,'aa') insert into view1 values(2,'bb') insert into view1 values(3,'cc') insert into view1 values(4,'dd') insert into view2 values(1,'aaaa') insert into view2 values(2,'bbbb') insert into view2 values(3,'cccc')create proc tview as select identity(int,1,1) ID,a.* into #tmp1 from view1 a select identity(int,1,1) ID,b.* into #tmp2 from view2 bselect a.name1,b.name2 from #tmp1 a left join #tmp2 b on a.id=b.id -------------------- aa aaaa bb bbbb cc cccc dd NULL --------------------
视图中有很多限制create table view1 (
id1 int,
name1 varchar(10)
)
gocreate table view2 (
id2 int,
name2 varchar(10)
)
goinsert into view1 values(1,'aa')
insert into view1 values(2,'bb')
insert into view1 values(3,'cc')
insert into view1 values(4,'dd')
insert into view2 values(1,'aaaa')
insert into view2 values(2,'bbbb')
insert into view2 values(3,'cccc')create proc tview
as
select identity(int,1,1) ID,a.* into #tmp1 from view1 a
select identity(int,1,1) ID,b.* into #tmp2 from view2 bselect a.name1,b.name2
from #tmp1 a left join #tmp2 b on a.id=b.id
--------------------
aa aaaa
bb bbbb
cc cccc
dd NULL
--------------------