Question6

Question 6

Get 'cid's of customers who order both product p01 and product p07. This means the customer has ordered p01 and also p07. These two products do not have to be on the same order but the customer must have ordered both products sometime.

SQL:

    (
        select distinct cid 
            from ord_order_line 
            where pid = 'p01'
    )
    intersect
    (
        select distinct cid 
            from ord_order_line 
            where pid = 'p07'
    );

Output:

    c001
    c006

mj (Sep 17, 2001 7:34 pm; Comment #1)

This one is mine! All mine!! Hahahahaha!!!!!

"Multiple exclamation marks," he went on, shaking his head, "are a sure sign of a diseased mind." - Terry Pratchett, Eric