UPDATE table t SET race_id = ( SELECT pkey_id FROM race r, (SELECT * from race where pkey_id = t.race_id) x WHERE r.track_id = 41 AND r.raceday = x.race_day AND r.race = x.race ) WHERE race_id in (select pkey_id from race where track_id = 37)