If I have the following (highly simplified) customer table how do I:
#1) Query for customers who *ONLY* bought apples
#2) Query for customers who bought apples *AND* bananas
#3) Query for customers who bought exactly 2 apples?
----------------------------------------------------------------------
DROP TABLE IF EXISTS Customers;
CREATE Table Customers (
EntryID INTEGER PRIMARY KEY,
CustomerID INT,
Type ENUM
);
INSERT INTO Customers VALUES (NULL, 1234, 'Banana');
INSERT INTO Customers VALUES (NULL, 1234, 'Banana');
INSERT INTO Customers VALUES (NULL, 1235, 'Apple');
INSERT INTO Customers VALUES (NULL, 1236, 'Banana');
INSERT INTO Customers VALUES (NULL, 1237, 'Banana');
INSERT INTO Customers VALUES (NULL, 1237, 'Banana');
INSERT INTO Customers VALUES (NULL, 1237, 'Apple');
INSERT INTO Customers VALUES (NULL, 1238, 'Apple');
INSERT INTO Customers VALUES (NULL, 1238, 'Apple');
INSERT INTO Customers VALUES (NULL, 1239, 'Apple');
INSERT INTO Customers VALUES (NULL, 1239, 'Banana');
--
Scott Baker - Canby Telcom
System Administrator - RHCE - 503.266.8253
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
