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)