``` sql UPDATE odoc SET osmlineid = s.osmlineid FROM odoc o INNER JOIN osmline s ON o.uniqueid = s.uniqueid; ```