Question

在oracle中现有两个表 table1 ,table2,要将两个表结合生成第三张表,语句该如何些?

Answer 1

select distinct a.id,a.name,c.score score2,b.score score1

(select distinct t.id,name from(select id,name from table1

union all

select id,name from table2) t) a,table1 b table2 c

where a.id=b.id(+)

and a.id=c.id(+)