(no subject)

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Tue, 02 Oct 2001 12:08:33 -0700
Message-ID: <F001.0039F435.20011002112034@fatcity.com>

You need the outer join on sp.status as well

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com

                                                                                       
                    
                    cgrabowy_at_fcg.                                                      
                    
                    com                  To:     ORACLE-L_at_fatcity.com                  
                    
                    Sent by:             cc:                                           
                    
                    root_at_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: cgrabowy_at_fcg.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).




-- 
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).

Received on Tue Oct 02 2001 - 14:08:33 CDT