Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

You can use Not Exists Join in Axapta 2012 following way. LedgerTable ledgerTable; LedgerTrans ledgerTrans; while select AccountNum, Name from ledgerTable notExists join * from ledgerTrans where (ledgerTable.AccountNum == ledgerTrans.AccountNum)