use T24V003 select SUM(TAKAMTS),SrNo from GREY_SEND_TO_MILL_TAKA_DETAIL where ItemName = 'JAAM 68 PICK' AND PurSrNo='' AND RFSrNo='' GROUP BY SrNo SELECT 602070.50-558278.10-56384.65+12592.25
use T24V003 select SUM(TAKAMTS),SrNo from GREY_SEND_TO_MILL_TAKA_DETAIL where ItemName = 'JAAM 68 PICK' AND PurSrNo='' AND RFSrNo='' GROUP BY SrNo SELECT 602070.50-558278.10-56384.65+12592.25