Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: A SQL solution possible?

From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
To: lambu999@xxxxxxxxx
Date: Tue, 05 Apr 2005 05:52:05 -0600

Try this

select b.DESIGNATION, b.YEAR, nvl(a.AVG_AMT,0), nvl(a.TOT_AMT,0), a.COMMENTS
from destination a,
  (select designation, year from account_tbl, fiscal_year) b
where a.designation(+) = b.designation
and a.fiscal_year(+) = b.year




Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 

--
http://www.freelists.org/webpage/oracle-l

References:

A SQL solution possible?
From: Ram K