Get list of vendors that doesn't have any Party location relation.

Finance and Operations/AX Developer Forum
1

Hi ALL,

I want get list of vendors from vend table which partyId is not available in DirPartyLocation Table.

kindly suggest

2

They are joined by PartyId, use a not exists join
while select AccountNum from vendTable
notexists join DirPartyLocation
where DirPartyLocation.PartyId == vendTable.PartyId
{
// do something
}

3

Please always tag your AX version.