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

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with SQL Sum across multiple tables

Re: Problem with SQL Sum across multiple tables

From: Biju Thomas <bijuthomas_at_email.msn.com>
Date: Tue, 4 Aug 1998 19:24:07 -0500
Message-ID: <eU6lLeAw9GA.175@upnetnews03> 





Try this...


If you need only naturalaccountid and sum_of_AAmount, you need not even join
table 1.


SELECT Glfact.naturalaccountID, sum(AAmount)
FROM   Glfact, Fact


WHERE  Glfact.Glfactid = Fact.Glfactid


GROUP BY Glfact.NaturalaccountId



--


Thanks,


Biju Thomas



For Oracle Scripts, Tips and Links


http://www.geocities.com/SiliconValley/Peaks/4535/oracle_main.htm




Received on Tue Aug 04 1998 - 19:24:07 CDT












Original text of this message













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