这是一个基本的计算器,能增加和减少VAT。 subtract 词典解释 1.减;减去 If you subtract one number from another, you do a calculation in which you take it away from the other number. For example, if you subtract 3 from 5, you get 2. ...
FROMAccounts A  JOIN (  SELECTS.AccountID ,ISNULL(SUM(CASEWHENS.dateandtime >= DT.DT14THENS.subtotalEND), 0)ASsubtotal14 ,ISNULL(SUM(CASEWHENS.dateandtime < DT.DT14THENS.subtotalEND), 0)ASsubtotal31 ,ISNULL(SUM(CASEWHENS.dateandtime >= DT.DT14THENS.vatEND), 0)AS...