Need help, urgent SQL query

[SDas]

mantra, without knowing your Database SQL I can only guess but this should work:

SELECT PORTINFOID, SUM(SUMOFVALUEAMT), COUNT(*) AS CNT FROM (

SELECT dbo.portinfo.PORTINFOID, Sum(dbo.loccvg.VALUEAMT) AS SumOfVALUEAMT, dbo.loccvg.LOCID
FROM (dbo.loc INNER JOIN dbo.loccvg ON dbo.loc.LOCID = dbo.loccvg.LOCID) INNER JOIN (dbo.portinfo INNER JOIN dbo.portacct ON dbo.portinfo.PORTINFOID = dbo.portacct.PORTINFOID) ON dbo.loc.ACCGRPID = dbo.portacct.ACCGRPID
GROUP BY dbo.portinfo.PORTINFOID, dbo.loccvg.LOCID
HAVING (((dbo.portinfo.PORTINFOID)=73) AND ((Sum(dbo.loccvg.VALUEAMT))>=50000 And (Sum(dbo.loccvg.VALUEAMT))<=100000))

) AS A
GROUP BY PORTINFOID
;