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 I have two tables in a database and I wish to copy text from one column of the table to another column in another table.

Lets say I have two tables called 'articles' and 'info'. I have to copy articles.article column text into info.description for the same articles, which can be identified by a so called 'Codename' and not ID. Preferably IF the column info.description is empty. I intend to use WHERE category = 4 to limit myself to only some articles, but that shouldn't be a problem and if the IF statement is correct even unnecessary.

Tables layout (Not whole, but enough for here):

Articles (ID, Codename (VARCHAR), Article (VARCHAR)) 
Info (ID2, Codename (VARCHAR), Description (VARCHAR))


So basically, I would like to give articles with no description a basic description with their name and some data, that is written beside the name.
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;