| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query help !!!
Is this what you are trying to do?
select a.customer_id
from table a, table b
where a.customer_id = b.customer_id and a.status = 'F' and b.status <> 'F'
Ron
rthomas_at_hypercom.com
ron_at_karaoke-time.com
"Karaoke: Japanese for migraine"
leslie_y_lu_at_y
ahoo.com To: ORACLE-L_at_fatcity.com
Sent by: cc:
root_at_fatcity. Subject: Query help !!!
com
06/22/01
10:51 AM
Please
respond to
ORACLE-L
Hi,
If I have this:
Customer_id Status
---------- -----------
1 F 1 A 1 B 2 F 2 F 3 A 3 B
How do I found out a customer who has both F and not F for them. (If he only gets F, or gets other than F, that's fine). In this case, I should get 1. Thank you! I need this badly!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: leslie_y_lu_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Jun 22 2001 - 13:06:40 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: rthomas_at_hypercom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |