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 there are the following attributes:
Foreign Keyfrom the
PRODUCT there are:
Primary Key) and
I want to add a column that gets the
PRICE from the
PRODUCT table and insert it to the
ORDERS table according to the
How can I do it? Are there any workarounds?
Please, keep in mind that I'm a newbie and my knowledge is very limited.