各位请帮看一下(菜鸟级别)
A表
cid kid gcm lxr eamil zjm
11大河 aa aa dh
21大野 dy dy dy
31美開杰国際貿易 DD DD mkj
41青島華和 dd dd qdhy
51寧波隆盛丸和ddddlbswh
B表
kid cid PF
11CMM16-7610
11CMM17-7611
12CMM13-7610
21CMM11-7810
想得到如下查询结果
kid cid gcm pf
1 1 大河 CMM16-7610
1 1 大河 CMM17-7611
1 2 大野 CMM13-7610
[解决办法]
Select b.kid,b.cid,a.gcm,b.pf from [表A] a,[表B] b Where a.cid = b.cid and b.kid = 1
你的条件旧kid = 1?
[解决办法]
--原始数据：@A
declare @A table(cid int,kid int,gcm varchar(14),lxr varchar(2),eamil varchar(2),zjm varchar(6))
insert @A
select 1,1, '大河 ', 'aa ', 'aa ', 'dh ' union all
select 2,1, '大野 ', 'dy ', 'dy ', 'dy ' union all
select 3,1, '美開杰国際貿易 ', 'DD ', 'DD ', 'mkj ' union all
select 4,1, '青島華和 ', 'dd ', 'dd ', 'qdhy ' union all
select 5,1, '寧波隆盛丸和 ', 'dd ', 'dd ', 'lbswh '
--原始数据：@B
declare @B table(kid int,cid int,PF varchar(11))
insert @B
select 1,1, 'CMM16-7610 ' union all
select 1,1, 'CMM17-7611 ' union all
select 1,2, 'CMM13-7610 ' union all
select 2,1, 'CMM11-7810 '
select a.kid,a.cid,a.gcm,b.PF from @A a join @B b on a.cid=b.cid and a.kid=b.kid
/*
kidcidgcmpf
11大河CMM16-7610
11大河CMM17-7611
12大野CMM13-7610
*/
[解决办法]
select b.kid,b.cid,a.gcm,b.PF from a,b where a.cid=b.cid and a.kid=1
