UPDATE `Table1` a LEFT JOIN `Table2` b ON a.Field1 = b.Field1 SET a.Field2 =Value WHERE a.Field3 =Value2 AND b.Field2=Value3