]
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 2 fields(cust# and item#)
CUST# ITEM#
1 '12a'
1 '13a'
2 '12a'
3 '13a'
4 '15a'
If I want to select
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 table
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
* 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