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

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

SELECT custTrans.Invoice, custTrans.AccountNum, custTrans.TransDate FROM custTrans JOIN offsetCustTrans ON offsetCustTrans.OffsetRecid = custTrans.RecId JOIN custTrans_W ON custTrans_W.CustTrans = custTrans.RecId WHERE custTrans.TransType = 'Sales' AND offsetCustTrans.TransType = 'Payment' AND offsetCustTrans.LastSettleVoucher = 1 AND custTrans_W.CustConsInvoice_JP = _consInvoice.RecId