主题：sqlselct 找出来行数据之后 的计算方法

Dim cmd4 As New SQLCommand

cmd4.C

cmd4.CommandText = "S ELECT c.fchrGatheringVouchDetailID ,Sum(c.flotCurrentAmount) as 求和 From {GatheringVouchDetail} as gvd inner join {StoredCardRecord} as c on gvd.fchrGatheringVouchDetailID = c.fchrGatheringVouchDetailID wh ere gvd.fchrGatheringVouchID = '" & gvid & "' group by c.fchrGatheringVouchDetailID "

Dim val As Integer = cmd4.ExecuteScalar()

msgbox(val)