SELECT id_field, field_to_update 
    FROM table_1 WHERE id_field NOT IN
    (SELECT join_id_field FROM table_2)