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)
