UPDATE
Table
SET
Table.col1 = other_table.col1,
Table.col2 = other_table.col2
FROM
Table
INNER JOIN
other_table
ON
Table.id = other_table.id
example:
update [Pharmapod].[dbo].[tbl_pharmacy]
set pharmacy_identifier = [Pharmapod].[dbo].[Table1].identifier
from
[Pharmapod].[dbo].[tbl_pharmacy]
inner join
[Pharmapod].[dbo].[Table1]
on
[tbl_pharmacy].registration_number = [Table1].number