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

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

SELECT generalJournalAccountEntry.*
FROM generalJournalAccountEntry
JOIN generalJournalEntry ON generalJournalEntry.RecId = generalJournalAccountEntry.GeneralJournalEntry
JOIN custTrans ON custTrans.Voucher = generalJournalEntry.subledgervoucher
JOIN custOutsideSalesTable ON custOutsideSalesTable.MtxOutsideSalesInvoiceId = custTrans.Invoice
                           AND custOutsideSalesTable.RecId = recId
WHERE generalJournalAccountEntry.PostingType <> 'Tax'
      AND generalJournalAccountEntry.TransactionCurrencyAmount <> 0;