X++ SQL 代码转换为 SQL Server 代码示例

以下是将 X++ 代码转换为 SQL Server 代码的结果：

SELECT taxTrans.TaxCode, SUM(taxTrans.SourceRegulateAmountCur) FROM taxTrans JOIN taxTable ON taxTable.TaxCode = taxTrans.TaxCode JOIN taxTransGeneralJournalAccountEntry ON taxTransGeneralJournalAccountEntry.TaxTrans = taxTrans.RecId JOIN generalJournalAccountEntry ON taxTransGeneralJournalAccountEntry.GeneralJournalAccountEntry = generalJournalAccountEntry.RecId GROUP BY taxTrans.TaxCode, taxTable.TaxName;