这个sql不好写
<Product>
ProductID, ProductName
----------------------------
P1 Proudct1
P2 Proudct2
<OrderDetail>
ProductID, CustID, OrderCount
------------------------------
P1 C1 1
P1 C2 3
P1 C3 1
P2 C1 1
P2 C2 3
P3 C1 1
P3 C2 5
P4 C1 1
如何将同时满足C1=1 AND C2=3的产品取出来,也就是说满足条件只有P1, P2两种产品
初始化表与数据的语句如下
CREATE TABLE Product(ProductID VARCHAR(10), ProductName VARCHAR(30))
CREATE TABLE OrderDetail(ProductID VARCHAR(10), CustID VARCHAR(10), OrderCount INT)
INSERT INTO Product VALUES('P1', 'Proudct1')
INSERT INTO Product VALUES('P2', 'Proudct2')
INSERT INTO OrderDetail VALUES('P1', 'C1', 1)
INSERT INTO OrderDetail VALUES('P1', 'C2', 3)
INSERT INTO OrderDetail VALUES('P1', 'C3', 1)
INSERT INTO OrderDetail VALUES('P2', 'C1', 1)
INSERT INTO OrderDetail VALUES('P2', 'C2', 3)
INSERT INTO OrderDetail VALUES('P3', 'C1', 1)
INSERT INTO OrderDetail VALUES('P3', 'C2', 5)
INSERT INTO OrderDetail VALUES('P4', 'C1', 1)
--DROP TABLE Product
--DROP TABLE OrderDetail