|
|
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.
Navigation:
[Reply to this message]
|