Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a Left Join BG B on a.QYMC=b.QYMC --左联接Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a Inner Join BG B on a.QYMC=b.QYMC --内联接 Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a Right Join BG B on a.QYMC=b.QYMC --右联接Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a,BG B on a.QYMC=b.QYMC --笛卡尔
select * from ZH a fulll join BG b on a.QYMC=b.QYMC
select A.*, B.NR from ZH A left join BG B on A.qymc = B.qymc
不好意思,错了一个。 Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a,BG B --笛卡尔
--合并 QYMC select QYMC=isnull(a.QYMC,b.QYMC) ,a.NL,a.DJH,a.ZC,a.ZW ,b.NR from ZH a full join BG b on a.QYMC=b.QYMC
select QYMC=isnull(a.QYMC,b.QYMC) ,a.NL,a.DJH,a.ZC,a.ZW ,b.NR into FG from ZH a full join BG b on a.QYMC=b.QYMC
Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a Right Join BG B on a.QYMC=b.QYMC --右联接Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a,BG B on a.QYMC=b.QYMC --笛卡尔
Select a.QYMC,a.NL,a.DJH,a.ZC,a.ZW,b.NR From ZH a,BG B --笛卡尔
select QYMC=isnull(a.QYMC,b.QYMC)
,a.NL,a.DJH,a.ZC,a.ZW
,b.NR
from ZH a
full join BG b on a.QYMC=b.QYMC
,a.NL,a.DJH,a.ZC,a.ZW
,b.NR
into FG
from ZH a
full join BG b on a.QYMC=b.QYMC
然后把第二个表的内容按QYMC对应加入是不是容易些?
怎么加啊?
麻烦高手了!分我可以再加的
我想实现的是根据QYMC一对一的对应,也就是说ZH里有的企业就对应出他的NR没有的就不写如
我根据你的写的QYMC不唯一了
select ZH.QYMC,NL,DJH,ZC,ZW,NR into newtable from ZH left join BG WHERE ZH.QYMC=BG.QYMC
试试