莫不是:
insert into TB (colA,colB)
select TA.colA, TC.colB from TA inner join TC on TA.colB=TC.colB
insert into TB (colA,colB)
select TA.colA, TC.colB from TA inner join TC on TA.colB=TC.colB
select TA.colA, TC.colC from TA inner join TC on TA.colB=TC.colB
insert into TB (colA,colB)
select TA.colA, TC.colB from TA inner join TC on TA.colB=TC.colB
insert into TB (colA,colB)
select TA.colA, TC.colB from TA inner join TC on TA.colB=TC.colB
insert into tb(tb.cola,colc)
select ta.cola,tc.colc from ta,tc where ta.colb=tc.colb
update TB set colA=a.colA from TA a where a.colB=TB.colBupdate TB set colC=a.colC from TC a where a.colB=TB.colB
insert into tb (cola,colc)
select ta.cola,tc.colc from ta inner join tc on ta.colb=tc.colb
--
TB存在不能用insert
???
--==
不知道是否有这样的说法,