对多行中的列值进行MySQL过滤？

Question

假设我有这两个表：

|Customers  |   |Purchases  | 
----------------   ----------------- 
|CusID   |-----  |PurchaseID  | 
|CusName  |  |---<|CusID   | 
|CusAge  |   |ItemName  | 
|CusDateAdded |   |DatePurchased | 

我需要筛选我的结果由多个itemNames的设置。假设我想退回所有年龄在18岁至24岁之间购买“相机”和“电话”的所有客户。当谈到时间，在采购表中是如何做的多行一个过滤器ITEMNAME列过滤然而

SELECT CusID 
FROM Customers AS C 
JOIN Purchases AS P 
ON C.CusID = P.CusID 
WHERE C.CusAge BETWEEN 18 AND 24 

：我可以运行下面的查询来获取所有记录年龄范围之间的客户？假设没有多个查询是可能的？

Answer 1

SELECT C.CusID 
FROM Customers AS C 
JOIN Purchases AS P ON C.CusID = P.CusID 
WHERE C.CusAge BETWEEN 18 AND 24 
AND ItemName IN ('camera','phone') 
GROUP BY C.CusID 
HAVING count(distinct ItemName) = 2 

集团由客户，并只返回这两个项目。

Answer 2

我相信这将会回答你的问题：SQL FIDDLE

SELECT C.CustID,C.CustName,P.ItemName 
FROM Customers AS C 
JOIN Purchases AS P ON C.CustID = P.CustID 
GROUP BY C.CustID,C.CustName,P.ItemName 
HAVING P.ItemName IN ('camera','phone')