SQL How to copy text from one table (from one column) to another table (to one column), preferably with IF the target column is empty
Although previous answer was correct, and I am thankful to @McNets, I found an easier way to do it.

UPDATE info i, articles a
SET i.Description = a.Article
WHERE i.Codename = a.Codename
AND i.Description IS NULL;