把以下X++ sql代码转化成sqlserver 的sql代码。select forupdate vendTransUpdate where vendTransUpdateMnkPayApprovalFlag == MnkPayApprovalFlagEnumNotApplicate join ledgerJour

以下是将X++代码转化为SQL Server的SQL代码：

SELECT vendTransUpdate.*
FROM vendTransUpdate
JOIN ledgerJournalTransLocal ON ledgerJournalTransLocal.VendTransId = vendTransUpdate.RecId
    AND ledgerJournalTransLocal.MnkMajourFlowFlag = 'No'
WHERE vendTransUpdate.MnkPayApprovalFlag = 'NotApplicate'
    AND EXISTS (
        SELECT 1
        FROM ledgerJournalTableLocal
        WHERE ledgerJournalTableLocal.JournalNum = ledgerJournalTransLocal.JournalNum
            --AND ledgerJournalTableLocal.Posted = 'Yes'
    )
    AND EXISTS (
        SELECT 1
        FROM ledgerJournalNameLocal
        WHERE ledgerJournalNameLocal.JournalName = ledgerJournalTableLocal.JournalName
            AND ledgerJournalNameLocal.JournalType = 'VendInvoiceRegister'
    )
    AND NOT EXISTS (
        SELECT 1
        FROM searchMnkMatchedTable
        WHERE searchMnkMatchedTable.RefRecId = vendTransUpdate.RecId
    )

请注意，由于代码中的一些条件是注释掉的，您需要根据实际情况取消注释或删除这些条件