Re: query problem (left outer join)

From: Nigel Thomas <nigel_at_preferisco.com>
Date: Mon, 2 Oct 2006 08:04:53 -0700 (PDT)
Message-ID: <20061002150453.83463.qmail@web54709.mail.yahoo.com>

Harvinder  

Include your tab3 BEFORE the outer join. Then no need for a subquery, no need to resolve a forward reference:

SELECT
    accmap.id_acc as id_acc,

    av.c_firstname as firstname, 
    av.c_lastname as lastname, 
    av.c_middleinitial as middleinitial, 
    av.c_zip as zip 

FROM
    Tab1 accmap
    INNER JOIN tab3 ed ON ed.nm = 'bill-to' LEFT OUTER JOIN tab2 av ON av.id_acc = accmap.id_acc AND av.c_contacttype = ED.ID WHERE accmap.id_acc in (345)  

Regards Nigel

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 02 2006 - 10:04:53 CDT