UPDATE u -- u is the table to be updated SET u.assid = s.assid FROM ud u INNER JOIN sale s ON u.id = s.udid