Oracle数据库,我要从5张表中各查出部分列,然后插入到一张新的表里面...答:COL3,COL4,COL5)SELECT A.ID,A.COL1,B.CO2,C.COL3,D.COL4,E.COL5FROM A,B,C,D,EWHERE A.ID = B.ID AND B.ID = C.ID AND C.ID = D.ID AND D.ID = E.ID AND NOT EXISTS(SELECT 1 FROM TEST WHERE TEST.ID = A.ID)同步的话,就用oracle的job吧,定期执行。