各位请帮看一下(菜鸟级别)
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