我有一个复合成分表。根据产品的不同,每种产品可能有多个成分号:
Product | Ingred No | 1 | B
---|---|
1 | |
2 | |
1 | |
2 | |
3 | |
1 | |
2 | |
3 | |
4 |
SELECT p.*
FROM product p
INNER JOIN (
(
SELECT product
FROM Ingreds
GROUP BY product
HAVING COUNT(0) >= 3
) g ON g.product = p.product