Populate column with values from another table in SQL

Update a table with column data from a related table (e.g. if you're in the process of removing the related table but need to keep reference data)

UPDATE TargetTable
SET TargetColumn = RelatedTable.ColumnToCopy
FROM TargetTable
JOIN RelatedTable
ON RelatedTable.Id = TargetTable.Id