X++ SQL to SQL Server Conversion: Selecting Tax Code and Name
SELECT TOP 1 TaxCode, TaxName FROM taxTable2 JOIN TaxOutgoingLedgerDimension ON taxTable2.TaxAccountGroup = TaxOutgoingLedgerDimension.TaxAccountGroup JOIN taxGroupData2 ON taxTable2.TaxCode = taxGroupData2.TaxCode JOIN taxOnItem2 ON taxTable2.TaxCode = taxOnItem2.TaxCode WHERE taxGroupData2.TaxGroup = '_mtxCustOutsideSalesLine.MtxTaxGroup' AND taxOnItem2.TaxItemGroup = '_mtxCustOutsideSalesLine.MtxTaxItemGroup';
原文地址: https://www.cveoy.top/t/topic/pbEh 著作权归作者所有。请勿转载和采集!