Update field1.table1 based on compound join between table1 and table2 - Oracle
update table1 set flag_column = 1
 where exists (select 1 from table2
                where table1.columnx = table2.columnx
                  and table1.columny = table2.columny)


This will update every row in table 1 where the x, y column combination exists in table2.