Summarization

[goterps1]

I have 4000+ records in DBO_MASTER table for Fund 49. I'm trying to get a total value of the Fund with the following SQL. Can you help with what I'm missing.

SELECT DBO_MASTER.FUND, Format((sum(DBO_MASTER.TOTSHRSISS)+sum(DBO_MASTER.TOTSHRSUISS))*DBO_PRICE.PRICE,"$#,###.00") as BALANCE
FROM DBO_MASTER INNER JOIN DBO_PRICE ON DBO_MASTER.FUND = DBO_PRICE.FUND
where DBO_MASTER.FUND = 49
group by DBO_MASTER.FUND;

 

[SkipVought]

Hi,

Try this...

SELECT DBO_MASTER.FUND
, Format((sum(DBO_MASTER.TOTSHRSISS)+sum(DBO_MASTER.TOTSHRSUISS))*DBO_PRICE.PRICE,"$#,###.00") as BALANCE

FROM       DBO_MASTER 
INNER JOIN DBO_PRICE
   ON DBO_MASTER.FUND = DBO_PRICE.FUND

where DBO_MASTER.FUND = 49

group by DBO_MASTER.FUND[b], DBO_PRICE.PRICE[/b];

Skip,

_[red][/red]