You have written the following:
[snip]
> 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?
SELECT CUST#, ITEM#
FROM
: "Smith, Mike" <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: RE: How can I do this SQL query
> Date: Thu, 23 May 2002 15:33:05 -0400
>
> How can I do this SQL query
>
> I have a file(transfile) that has
* 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 ca
How can I do this SQL query
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 '13
