如有两个表 T1, T2T1
custom sex age country
Jack m 21 USA
Tom m 24 USA
May w 24 CHS
KAKA m 40 JAP
T2
Name age company
Jack 21 HP
Tom 24 IBM
MAy 24 lenovo
如何把表T2的内容追加到表T1T1
custom sex age country company
Jack m 21 USA HP
Tom m 24 USA ibm
May w 24 CHS lenovo
YAKA m 40 JAP
custom sex age country
Jack m 21 USA
Tom m 24 USA
May w 24 CHS
KAKA m 40 JAP
T2
Name age company
Jack 21 HP
Tom 24 IBM
MAy 24 lenovo
如何把表T2的内容追加到表T1T1
custom sex age country company
Jack m 21 USA HP
Tom m 24 USA ibm
May w 24 CHS lenovo
YAKA m 40 JAP
(select company from t1,t2 where t1.name=t2.name);
(select t2.company from t1,t2 where t1.name=t2.name);
select custom,sex,t1.age,country,company
from t1,t2
where t1.custom=t2.name(+);
select a.custom,a.sex,a.age,a.country,b.company
from t1 a left join on a.name=b.name
using t2
on (t1.custom = t2.name)
when matched then
update t1.company = t2.company
/
SELECT T1.custom T1.sex T1.age T1.country T2.company
FROM T1,T2
WHERE t1.custom=t2.name(+);