Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
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?
try separating them into two blocks:
select firstOnly t where t.x == header.x
//Your Code here
It needs to be written in two seperate blocks.
Business Applications communities