View Single Post
  #2 (permalink)  
Old 02-24-10, 16:34
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,448
Your query can be explained in plain English as "select all orders of 3 hamburgers or those where food was of type soup", so the result you get corresponds to what you've asked.

What you need is more like "select customers for whom exist orders of some soup AND exist orders of 3 hamburgers"; as you can see this is almost exactly the text of problem 11 in your assignment. Note that "exists" is a valid SQL predicate.
Reply With Quote