FreeLists / oracle-l / query problem (left outer join)

["Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>]

Hi,

 

We are getting following error while running the following query:

 

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

          LEFT OUTER JOIN tab2 av ON av.id_acc = accmap.id_acc

            AND av.c_contacttype = 

             (SELECT id FROM tab3 ed WHERE ed.nm = 'bill-to')

        WHERE

        accmap.id_acc in (345)

 

   SELECT

*

ERROR at line 1:

ORA-01799: a column may not be outer-joined to a subquery

 

What is the other possible option to rewrite this query as a workaround
for this error?

(We can't move the AND clause after where since that will change the
semantics of the query)

 

Thanks

--Harvinder