Using An Inhaler For Anemia

microsoft sql certification

This time I have seen the need to massively update the values \u200b\u200bof a column in a table with values \u200b\u200bfrom another table .
The sql query that I have left is:

UPDATE table SET field = CampoDeLaOtraTabla
FROM table inner join
OtraTabla tabla.id = OtraTabla.id
ON WHERE filter = FiltroQueQueramos
Note: It is necessary to use a WHERE statement