SQL select of records from table A but not in table B

Please, can someone help me find the SQL statement that select all records in TABLE_A except those whose combination of FIELD_1, FIELD_2 is not present in TABLE_B.

(In DB2)

Answer

You can simply use NOT EXISTS:

select * from table_a ta
where not exists (select * from table_b tb
                  where tb.field_1 = ta.field_1
                    and tb.field_2 = ta.field_2)