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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
