Re: Outer Join (?) Problem

From: <pollachi_at_my-deja.com>
Date: Thu, 31 Aug 2000 01:35:02 GMT
Message-ID: <8okco5$u1c$1@nnrp1.deja.com>

Try this :

select e.org_id, e.ec_type, e.ec_dol_mth, e.ec_dol_ytd,

       b.ec_tot_dol_mth, b.ec_tot_dol_ytd   from eom_ec_data e, btm_ec_data b

where e.fy_yr = 1999
  and e.data_dt = '31-OCT-99'
  and e.org_id   = b.org_id (+)
  and e.ec_type = b.ec_type (+)
  and b.model_id(+) = 24

union
select b.org_id, b.ec_type, e.ec_dol_mth, e.ec_dol_ytd,

       b.ec_tot_dol_mth, b.ec_tot_dol_ytd   from eom_ec_data e, btm_ec_data b

where e.fy_yr(+) = 1999
  and e.data_dt(+) = '31-OCT-99'
  and e.org_id (+) = b.org_id
  and e.ec_type (+) = b.ec_type
  and b.model_id(+) = 24

HTH Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 30 2000 - 20:35:02 CDT