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

SELECT SUM(SumTax) AS SumTax, CurrencyCode
FROM custInvoiceJour
JOIN custInvoiceJourW ON custInvoiceJourW.CustInvoiceJour = custInvoiceJour.RecId
WHERE custInvoiceJourW.CustConsInvoice_JP = this.RecId
GROUP BY CurrencyCode
把以下的X++ sql代码转换成 sqlserver sql代码:select sumSumTax CurrencyCode from custInvoiceJour group by CurrencyCode exists join custInvoiceJourW where custIn

原文地址: http://www.cveoy.top/t/topic/iXw7 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录