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
It needs to be written in two seperate blocks.
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
}
}
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156