web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) selecting record from ...

Microsoft Dynamics AX (Archived)

selecting record from a table that does not exist in other two tables(notexists join)

(0) Share

Report

Report

Posted on by Dev

451

Hi All,

I have 2 tables header and line each having a field x now I have to compare it with table t having field x , if the header has line we need to compare header.x == t.x else line.x== t.x. I need to filter records where the value is present in only header I.e it has no line records and no record in table t (header.recid == line.refrecid). I was trying two not exists join but that does not work in ax

while select header

notexists join line where line.refrecid == header.recid

notexists join t where t.x == header.x

{}

Can someone suggest an alternative?

Thanks,

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

try separating them into two blocks:

while select header

notexists join line where line.refrecid == header.recid

{

select firstOnly t where t.x == header.x

if (!t.RecId)

{

//Your Code here

}

}

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

It needs to be written in two seperate blocks.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans