try:SELECT tblMainAccount.Account,
tblMainAccount.OringinalCurrency,
convert(int,SUM((case when [InOrOut] = [收] then [Amount] else - 1 * [Amount] end) * 100 + 0.5) / 100) AS Amt
FROM (tblUserGroup INNER JOIN
tblUser ON tblUserGroup.CompanyNameSino = tblUser.CompanyNameSino)
INNER JOIN
(tblAccount INNER JOIN
tblMainAccount ON (tblAccount.Account = tblMainAccount.Account) AND
(tblAccount.Account = tblMainAccount.Account)) ON
tblUser. [USER] = tblMainAccount. [USER]
tblMainAccount.OringinalCurrency,
convert(int,SUM((case when [InOrOut] = [收] then [Amount] else - 1 * [Amount] end) * 100 + 0.5) / 100) AS Amt
FROM (tblUserGroup INNER JOIN
tblUser ON tblUserGroup.CompanyNameSino = tblUser.CompanyNameSino)
INNER JOIN
(tblAccount INNER JOIN
tblMainAccount ON (tblAccount.Account = tblMainAccount.Account) AND
(tblAccount.Account = tblMainAccount.Account)) ON
tblUser. [USER] = tblMainAccount. [USER]
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货