Populate columns of table with other table that doesn't have relationship
The more compact way to write this would be:

UPDATE Products
SET factor1 = article.factor1
from Article
WHERE Article.id = Products.id and products.factor1 is null