UPDATE provider SET provider.identifier = users.username, provider.creator = users.creator, provider.date_created = users.date_created, provider.retired = users.retired, provider.uuid = users.uuid
FROM provider INNER JOIN users ON provider_id = user_id