Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matta0990
Starting Member
44 Posts |
 Posted - 2011-09-07 : 04:19:37
|
| Hi, i'm trying to SUM up the combined results from a field. BUT the field is based on a number of diffrent INNER JOINS from 11 tables. My query returns the results i want e.g.NAME LineType VolumeBIOMASS BUNKER 1 OpeningBalance 100.00BIOMASS BUNKER 1 ConsumptionBIOMASS BUNKER 1 InterimBalance1BIOMASS BUNKER 1 TotalReceiptsBIOMASS BUNKER 1 InterimBalance2BIOMASS BUNKER 1 TotalSalesBIOMASS BUNKER 1 TotalTransfersBIOMASS BUNKER 1 InterimBalance3BIOMASS BUNKER 1 TotalReclaimBIOMASS BUNKER 1 InterimBalance4BIOMASS BUNKER 1 TotalConsumptionBIOMASS BUNKER 1 ClosingBalanceBIOMASS BUNKER 2 OpeningBalance 2000.000BIOMASS BUNKER 2 ConsumptionBIOMASS BUNKER 2 InterimBalance1BIOMASS BUNKER 2 TotalReceiptsBIOMASS BUNKER 2 InterimBalance2BIOMASS BUNKER 2 TotalSalesBIOMASS BUNKER 2 TotalTransfersBIOMASS BUNKER 2 InterimBalance3BIOMASS BUNKER 2 TotalReclaimBIOMASS BUNKER 2 InterimBalance4BIOMASS BUNKER 2 TotalConsumptionBIOMASS BUNKER 2 ClosingBalanceBIOMASS BUNKER 3 OpeningBalance 500.00BIOMASS BUNKER 3 ConsumptionBIOMASS BUNKER 3 InterimBalance1BIOMASS BUNKER 3 TotalReceiptsBIOMASS BUNKER 3 InterimBalance2BIOMASS BUNKER 3 TotalSalesBIOMASS BUNKER 3 TotalTransfersBIOMASS BUNKER 3 InterimBalance3BIOMASS BUNKER 3 TotalReclaimBIOMASS BUNKER 3 InterimBalance4BIOMASS BUNKER 3 TotalConsumptionBIOMASS BUNKER 3 ClosingBalanceBIOMASS BUNKER 4 OpeningBalance 4000.000BIOMASS BUNKER 4 ConsumptionBIOMASS BUNKER 4 InterimBalance1BIOMASS BUNKER 4 TotalReceiptsBIOMASS BUNKER 4 InterimBalance2BIOMASS BUNKER 4 TotalSalesBIOMASS BUNKER 4 TotalTransfersBIOMASS BUNKER 4 InterimBalance3BIOMASS BUNKER 4 TotalReclaimBIOMASS BUNKER 4 InterimBalance4BIOMASS BUNKER 4 TotalConsumptionBIOMASS BUNKER 4 ClosingBalanceBIOMASS BUNKER 5 OpeningBalanceBIOMASS BUNKER 5 ConsumptionBIOMASS BUNKER 5 InterimBalance1BIOMASS BUNKER 5 TotalReceiptsBIOMASS BUNKER 5 InterimBalance2BIOMASS BUNKER 5 TotalSalesBIOMASS BUNKER 5 TotalTransfersBIOMASS BUNKER 5 InterimBalance3BIOMASS BUNKER 5 TotalReclaimBIOMASS BUNKER 5 InterimBalance4BIOMASS BUNKER 5 TotalConsumptionBIOMASS BUNKER 5 ClosingBalanceBIOMASS BUNKER 6 OpeningBalanceBIOMASS BUNKER 6 ConsumptionBIOMASS BUNKER 6 InterimBalance1BIOMASS BUNKER 6 TotalReceiptsBIOMASS BUNKER 6 InterimBalance2BIOMASS BUNKER 6 TotalSalesBIOMASS BUNKER 6 TotalTransfersBIOMASS BUNKER 6 InterimBalance3BIOMASS BUNKER 6 TotalReclaimBIOMASS BUNKER 6 InterimBalance4BIOMASS BUNKER 6 TotalConsumptionBIOMASS BUNKER 6 ClosingBalanceETC.....rite, i need to sum up the combined total of VOLUME, for each BIOMASS BUNKER when the LINE TYPE is OpeningBalance. I carnt get it to work as the fileds, BIOMASS BUNKER 1,2,3 etc..., volume are fields within a table but OpeningBalance are results produced by the query.....Any Ideas?J Smith |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-07 : 04:23:45
|
do likeselect NAME ,SUM(VOLUME) as totlvolfrom(your current query)twhere LineType ='OpeningBalance'GROUP BY Name ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SUM Function using fields accross tables