update a table by selected value from other table.

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