假设表1名为：table1表2为：table2表3为：table3select a.plan,a.unit,b.plan,b.unit,c.URL into new_tablefrom table1 aleft join table2 b on a.mark=b.markleft join table3 c on c.URL=b.mark试试行不行
