Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: query problem (left outer join)

From: Nigel Thomas <nigel@xxxxxxxxxxxxxx>
To: Harvinder.Singh@xxxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 2 Oct 2006 08:04:53 -0700 (PDT)

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

References:

query problem (left outer join)
From: Harvinder Singh

Other related posts:

query problem (left outer join)

Re: query problem (left outer join)

RE: query problem (left outer join)