How to use Not Exists Join in Axapta 2012
Views (29263)
SANTOSH KUMAR SINGH
1,224
Like
Share
ReportYou 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)
LedgerTable ledgerTable;
LedgerTrans ledgerTrans;
while select AccountNum, Name from ledgerTable
notExists join * from ledgerTrans where (ledgerTable.AccountNum == ledgerTrans.AccountNum)
This was originally posted here.
*This post is locked for comments