把以下的X++ sql代码转换成 sqlserver sql代码:select firstonly TaxCode TaxName from taxTable2 join TaxOutgoingLedgerDimension from taxLedgerAccountGroup2 where taxTable2TaxAcc
SELECT TOP 1 TaxCode, TaxName FROM taxTable2 INNER JOIN taxLedgerAccountGroup2 ON taxTable2.TaxAccountGroup = taxLedgerAccountGroup2.TaxAccountGroup INNER JOIN taxGroupData2 ON taxTable2.TaxCode = taxGroupData2.TaxCode INNER JOIN mtxCustOutsideSalesLine ON taxGroupData2.TaxGroup = mtxCustOutsideSalesLine.MtxTaxGroup INNER JOIN taxOnItem2 ON taxTable2.TaxCode = taxOnItem2.TaxCode AND taxOnItem2.TaxItemGroup = mtxCustOutsideSalesLine.MtxTaxItemGroup;
原文地址: http://www.cveoy.top/t/topic/i0Tr 著作权归作者所有。请勿转载和采集!