title: Mysql add an existing column to another table
body: <p>I have several tables in a database. In table <code>products_info</code> one of the column is named <code>short_description</code> (Short description of a product) and has some values</p>
  
  <p><a href="https://i.stack.imgur.com/aD1Zm.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aD1Zm.jpg" alt="I need the value present in the short_description"></a></p>
  
  <p>In table <code>order-items</code> I need to add the <code>short_description</code> column with the data from short_description present in Table <code>products_info</code>.</p>
  
  <p><a href="https://i.stack.imgur.com/gp9mc.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gp9mc.jpg" alt="enter image description here"></a></p>
  
  <p>Any suggestions?
  Thank you.</p>