create table base (base_id char(2),base_nm char(20))
insert into base values( '00 ', '杭州店 ')
insert into base values( '01 ', '温州店 ')
insert into base values( '02 ', '宁波店 ')
create table goods (goods_id char(6),goods_nm char(20))
insert into goods values( '1001 ', '饼干 ')
insert into goods values( '1002 ', '苹果 ')
insert into goods values( '1003 ', '香蕉 ')
select base_id,base_nm,goods_id,goods_nm
into #temp1
from base a left join goods b
on 1=1
select * from #temp1
select * from goods,base
create table base (base_id char(2),base_nm char(20))
insert into base values('00','杭州店')
insert into base values('01','温州店')
insert into base values('02','宁波店')
create table goods (goods_id char(6),goods_nm char(20))
insert into goods values('1001','饼干')
insert into goods values('1002','苹果')
insert into goods values('1003','香蕉')
select base_id,base_nm,goods_id,goods_nm
into #temp1
from base a left join goods b
on 1=1