Re: Sql query!!

From: <Rick_Cale_at_teamhealth.com>
Date: Mon, 21 Jan 2002 05:49:40 -0800
Message-ID: <F001.003F5A02.20020121053025@fatcity.com>

You may also need nisse2.name(+) if nisse2 record does not exist.

Rick

                                                                                       
                            
                    Roland.Skoldb                                                      
                            
                    lom_at_ica.se           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    Sent by:             cc:                                           
                            
                    root_at_fatcity.        Subject:     Sql query!!                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    01/21/2002                                                         
                            
                    07:10 AM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L

Hallo,

Will this query work if I want to pick out the field id from nisse1, and that field doesnt hgave a value in nisse2. If it doesnt work please help me.

select nisse1.NAMn, nisse1.id
from nisse1, nisse2
where nisse1.id= nisse2.idn(+)
and nisse1.namn = nisse2.name

Thanks in advance

Roland

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Roland.Skoldblom_at_ica.se

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: 
  INET: Rick_Cale_at_teamhealth.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 Mon Jan 21 2002 - 07:49:40 CST