Who can tell me how to merge two reports into one report in oracle?

Select name, amount (currency)

(

Select name and currency from A.

Joint ownership

Select name and currency from B.

/* Combine two tables as temporary tables */

)

Group by name