How to add a column from another table? I'm starting to using SQL statements in my Oracle database XE (tables and relations made by me) and I'm having a hard time to understand how can I put a column from another table. 

The example in this case is: 


I have two tables that are interconnected, ORDERS and PRODUCT. 


In ORDERS there are the following attributes: 


ORDERID (defined as Primary Key), PRODUCT_NAME (a Foreign Key from the PRODUCT table) and QUANTITY. 


In PRODUCT there are: 


NAME (defined as Primary Key) and PRICE. 


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 a newbie and my knowledge is very limited.
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.