今度はinsert into t1 が抜けてた…orz
ML汚してすんません
これが間違っててももう黙ります

insert into t1(name, tel1, tel2, tel3)
select t1.name, t2_1.tel, t2_2.tel, t2_3.tel
from t1,
t1 as t1_1 left outer join t2 as t2_1 on t1_1.code1 = t2_1.code,
t1 as t1_2 left outer join t2 as t2_2 on t1_2.code2 = t2_2.code,
t1 as t1_3 left outer join t2 as t2_3 on t1_3.code3 = t2_3.code
where t1.name = t1_1.name
and t1.name = t1_2.name
and t1.name = t1_3.name;


--------------------------------------
GANBARE! NIPPON!
Yahoo! JAPAN JOC OFFICIAL INTERNET PORTAL SITE PARTNER
http://pr.mail.yahoo.co.jp/ganbare-nippon/