group by加筛选条件

[commemoration]

select ID count(*) as Count from TB_UserTradeActiveTradeMark where ID!=1 and Pid in( select Pid from tab where WID=7 and ID=17) group by ID

上面是一个Group By语句，现在我有另个表:tab2,里面有ID,NAME字段，这的ID和上面语句中select ID count(*)的ID是一致的，现在要根据上面语句的ID和tab2表中的ID关联出NAME这个字段，怎么关联？？？

[hovy_yang]

select a.ID,b.name count(*) as Count 
from TB_UserTradeActiveTradeMark a
join tab2 b on a.ID=b.ID
where a.ID<>1 and
 exists( select * from tab where a.Pid=Pid and WID=7 and ID=17) 
group a.ID,b.name

[delphilrj]

select b.name from 表1 a,表2 b where a.id=b.id

[claro]

--try
select a.ID,b.NAME count(*) as Count 
from TB_UserTradeActiveTradeMark a
join tab2 b on a.ID=b.ID
where a.ID<>1 and
 exists( select * from tab where a.Pid=Pid and WID=7 and ID=17) 
group a.ID,b.NAME

[duanzhi1984]

select a.ID,NAME count(*) as Count 

from TB_UserTradeActiveTradeMark a join 
tab2 b on a.ID=b.ID
where a.ID!=1 and Pid in( select Pid from tab where WID=7 and ID=17) 

group by a.ID,NAME

[Rotel-刘志东]

select a.ID,b.NAME count(*) as Count 
from TB_UserTradeActiveTradeMark a
join tab2 b on a.ID=b.ID
where a.ID<>1 and
 exists( select * from tab where a.Pid=Pid and WID=7 and ID=17) 
group a.ID,b.NAME

[ff284996867]

select a.id,b.name,count(1) as count
from TB_UserTradeActiveTradeMark a,tab2 b
where a.id != 1 and a.pid in (select pid from tab where wid = 7 and id = 17)
and a.id = b.id
group by a.id,b.name