SELECT A.* FROM A JOIN ( SELECT F_id, COUNT(*) c FROM B GROUP BY F_id HAVING COUNT(*) > 某一个数 ) B1 ON B1.F_id = A.F_id
SELECT A.*, B1.c ...
select a.F_id,a.Names,isnull(b.qty,0) '数量' from 表A a left join (select F_id,count(1) 'qty' from 表B group by F_id) b on a.F_id=b.F_id where isnull(b.qty,0)>[某一个数]
FROM A
JOIN ( SELECT F_id, COUNT(*) c
FROM B
GROUP BY F_id
HAVING COUNT(*) > 某一个数
) B1
ON B1.F_id = A.F_id
...
select a.F_id,a.Names,isnull(b.qty,0) '数量'
from 表A a
left join (select F_id,count(1) 'qty'
from 表B
group by F_id) b on a.F_id=b.F_id
where isnull(b.qty,0)>[某一个数]