How to add a column from another table?
The original question was:


  I want to add a column that gets the PRICE from the PRODUCT table and
  insert it to the ORDERS table according to the PRODUCT_NAME,
  obviously. How can I do it? Are there any workarounds? Please, keep in
  mind that I'm newbie and my knowledge is very limited.


and the ultimate reply (after much communication through comments - see above), my response was 


  And you can't use triggers to make updating automatic? I'd say they
  are the way to go!


Which worked.