QUERY with NOT IN to Exclude DatatItem / Sub-Select

primeap

Hello is it possibile to achieve something like that in NAV Query Object:

select *
from table e
where id NOT IN
 (select id
  from anothertable
  where id = e.id
 )

?

Any hint?

Kishorm

Unfortunately not

Kishorm

Unfortunately not

RockWithNAV

I believe you cant do this in Query but in other Objects obviously you can.