How do I use `notexists join` in X++?

Question

How do I use notexists join in X++?

Answer 1

SSunny Vasty75 reputation · answered Aug 13, 2026

Use notexists join when you want records that do not have a related record.

CustTable  custTable;
SalesTable salesTable;

while select custTable
    notexists join salesTable
        where salesTable.CustAccount == custTable.AccountNum
{
    info(custTable.AccountNum);
}

This is cleaner than selecting everything and then checking for missing related records in X++.

1 answer

Know the solution?