Posted by Ed Murphy on 04/18/07 06:28

tizmagik@gmail.com wrote:

> That first one didn't work for me, some syntax error, not sure why,
> might just be a phpMyAdmin problem,

You do realize this isn't a MySQL group?

> but that second one worked beautifully.
>
> I'm trying to step through it and understand it line by line now...
> this is what I understand from it:
>
> You are selecting all the customers that are not in the following:
> - You are selecting all the Items that john prefers, from the list of
> items that are not in the list of items that customers have bought

For each customer, you're looking for items that John prefers
but the customer didn't buy; if there is no such item, then the
customer gets selected.

[Back to original message]