* Smith, Mike
> I have a file(transfile) that has 2 fields(cust# and item#)
>
> CUST# ITEM#
> 1 '12a'
> 1 '13a'
> 2 '12a'
> 3 '13a'
> 4 '15a'
>
> If I want to select customers that have ordered item '12a' but not '13a'
> How can I do this?
>
> I want to end up with a result of only customer 2 in this case.
Maybe something like this:
SELECT cust
FROM
transfile AS t1
LEFT JOIN transfile AS t2 ON
t2.cust = t1.cust AND
t2.item = '13a'
WHERE
t1.item = '12a' AND
ISNULL(t2.item)
--
Roger
sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
