Left Outer Join in Ax 2012
Views (15314)
SANTOSH KUMAR SINGH
1,224
Like
Share
ReportYou can use Left Outer Join in Ax 2012 following way. There is no Right Outer join in Ax 2012. Default outer joint is left outer join so there is not left keyword is used in query.
while select AccountNum from LedgerTable order by AccountNum
outer join * from LedgerTrans where LedgerTrans.AccountNum ==
LedgerTable.AccountNum
{
info(strfmt("%1-%2", LedgerTable.AccountNum, LedgerTrans.AmountMst));
}
while select AccountNum from LedgerTable order by AccountNum
outer join * from LedgerTrans where LedgerTrans.AccountNum ==
LedgerTable.AccountNum
{
info(strfmt("%1-%2", LedgerTable.AccountNum, LedgerTrans.AmountMst));
}
This was originally posted here.
*This post is locked for comments