Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Outer Join (?) Problem
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
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
![]() |
![]() |