Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: A SQL solution possible?

Re: A SQL solution possible?

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 05 Apr 2005 05:52:05 -0600
Message-Id: <6.2.0.14.2.20050405055125.048d69c0@pop.centrexcc.com> 





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


Received on Tue Apr 05 2005 - 07:56:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US