Oracle sql query

[etl.infor]

hi,

trying to get the below output from the products and price tables.

products
NUM NAME
------ ---------
1 xxxx
2 yyyy
3 zzzzz

price
NUM PRICE
---- ----------
1 10
2 20
30

output
num name price
1 xxxxx 10
2 yyyy 20
3 yyyy 30

[Hack]

Something like

select prod.num, prod.name, pri.num, pri.price
from products prod
inner join price pri on pri.num = prod.num