query problem (left outer join)

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 2 Oct 2006 10:41:01 -0400

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006