-
UPDATE Table1SET filed1 = b.filed1FROM Table1 a JOIN Table2 b on a.ID = b.IDWHERE a.name = 'YOU' and b.number > 1000