34,575
社区成员
发帖
与我相关
我的任务
分享
create table #t1(...)
insert into #t1
select * from table1 where name like 'abc%'
create table #t2(...)
insert into #t2
select * from table2 where id > 20
create table #t3(....)
insert into #t3
select * from table3 where price < 100
select a.* from #t1 a, #t2 b, #t3 c where a.id = b.id and a.id = c.id
select * into #1 from table1 where name like 'abc%'
select * into #2 from table2 where id > 20
select * into #3 from table3 where price < 100
select a.* from #1 a, #2 b, #3 c where a.id = b.id and a.id = c.id