query problem (left outer join)

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
 

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 02 2006 - 09:41:01 CDT