Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table normal(val_one int, val_two int, bool_val varchar(10));
insert into normal values(1, 2, False);
insert into normal values(3, 4, False);

CREATE TABLE

INSERT 0 1

INSERT 0 1

create table temp(val_one int, val_two int, bool_val varchar(10));
insert into temp values(1, 2, True);

CREATE TABLE

INSERT 0 1

SELECT val_one, val_two, bool_val FROM normal n
where not exists 
     (
          SELECT 1 FROM temp t  where t.val_one=n.val_one and t.val_two=n.val_two
      )

val_one
val_two
bool_val

3
4
false

SELECT 1