Write a query to fetch values in table table_a that are and not in table_b without using the NOT keyword :-

create table TableA(id numeric);

create table TableB(id numeric);

insert into TableA(id) values

(10),

(20),

(30),

(40),

(50);

insert into TableB(id) values

(10),

(30),

(50);

Answers

select * from TableA;

except

select * from TableB;

results matching ""

    No results matching ""