直接用count就可以了，这样：select COUNT(*) AS CNTfrom tableA as a,tableB as b,table C as c where a.id=b.typeid and b.addid=c.idgroup by b.id,b.name,c.address,a.type但是你怎么还要用group BY呢？如果只是满足where条件的总数的话，就要去掉group by
