Hi, I am trying to get the elements of B not in A. My code is like this
C = JOIN A BY id RIGHT OUTER, B BY id; D = FILTER C BY A::id is null; id is an INT, and this doesn't work. I also tried A::id != B::id, (chararray)A::id == '', both also didn't work. Can someone tell me how I should do it. Any help is appreciated. Thanks Kent