Ron,
An outer join on sp.status will only return records from s if no records
exist in the sp table.
If a record exists in the sp table, it HAS to be a value of 'A'.
I suggest he drop the 'and' clause altogether.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, October 02, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
You need the outer join on sp.status as well
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
cgrabowy@fcg.
com To: [EMAIL PROTECTED]
Sent by: cc:
root@fatcity. Subject:
com
10/02/01
12:00 PM
Please
respond to
ORACLE-L
SELECT s.study_id, s.status, sp.status
FROM s, sp
WHERE s.study_id = 5014
AND s.study_id = sp.study_id(+)
AND s.status = 'A'
AND sp.status(+) = 'A' -- outer join here as well
What am I missing??!?!?!?
TIA!!!!
Chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
