如有两个表:
表A
字段:
name sex
john male
rose female表B
字段:
name ... buy
john .... ineve
rose .... pc
rose .... dell
rose .... ibm
john .... micro要求查出在表B中name字段出现指定次数的记录,比如在name中出现2次则查出:
name sex buy
john male ineve
john male micro
表A
字段:
name sex
john male
rose female表B
字段:
name ... buy
john .... ineve
rose .... pc
rose .... dell
rose .... ibm
john .... micro要求查出在表B中name字段出现指定次数的记录,比如在name中出现2次则查出:
name sex buy
john male ineve
john male micro
Where name in
(Select name from 表B Group by name Having Count(name)=2)
SELECT a.name, a.sex, b.buy
FROM a INNER JOIN
b ON a.name = b.name
WHERE (b.name IN
(SELECT name
FROM b
GROUP BY name
HAVING (COUNT(name) = 2)))