3,494
社区成员




insert iinto c
(
select b.id1,b.id2,a.name,a.test1,a.test2 from a ,b where a.name = b.name(+)
)
INSERT INTO C
(SELECT B.ID1,
B.ID2,
A.NAME,
A.TEST1,
A.TEST2
FROM A,
B
WHERE A.NAME = B.NAME)