Use a view to join two of the tables, then join the view to the third
Russ Conway wrote in message <36E02F61.607B0149_at_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 Sat Mar 06 1999 - 00:23:36 CST
