I am trying to compare a similar field in 2 tables to find where entry exists in tab1 but not in tab2. I am running the following sql to get this but can't find what I am doing wrong. Any help would be greatly appreciated.
when I run this:
select tab1.dets_t from tab1 where tab1.dets_t not in ( tab2.dets_t );
I get error:
217: Column (tab1) not found in any table in the query (or SLV is undefined).
Error in line 1
Near character position 56