Happy new year to you!
I am having a strange problem today, which I can hardly understand! Thus I wanted to ask you!
I have a very simple query, which used to work as far as I remember. Now, however, the query doesn't return any rows at all. Can you please tell me what is wrong? CNT_GEBIET is a string just like lng_gebiet. Both are varchar2.
I simply need to output all records of table tbl_gebiet, which are non existent in tbl_arbeit_zu_gebiet.
I appreciate your help and am very curious if you have any ideas!
Select distinct cnt_gebiet from VT_TBL_GEBIET where cnt_gebiet not in (Select distinct lng_gebiet from VT_TBL_ARBEIT_ZU_GEBIET)