ORA-01417

From: Russ Conway <russ_conway_at_NOSPAMgm.cytec.com>
Date: Fri, 05 Mar 1999 14:24:18 -0500
Message-ID: <36E02F61.607B0149@NOSPAMgm.cytec.com>

I'm having a problem joining three tables with the following query:

select

        ecl.lord,
        ecl.lline,
        ecl.lwhs,
        to_char(floor(ech.hstore/100)),
        ech.hcust,
        to_char(to_number(i_ux.uxgrp)),
        ecl.lprod,
        ecl.lnet,
        ecl.lqord,
        ecl.lqshp,
        DECODE(ecl.lscdt, 0, NULL,
                             to_date(ecl.lscdt, 'yyyymmdd'))

from bpcs.i_ux, bpcs.ech, bpcs.ecl
where lord = hord(+) and

      floor(ech.hstore/100) = uxdept(+) and
      lprod = uxprod(+) and
      hid <> 'CZ'

;

I keep getting...

ORA-01417: a table may be outer joined to at most one other table

I would like to join ecl to ech (outer join) and then join the results of that to i_ux (outer join). Can this be done? Do I need a view or a subquery? Received on Fri Mar 05 1999 - 13:24:18 CST