假如我有数据 a,b,c,d,f,g 我要把 a,b,c,d 插入table1 把 a,f,g 插入table2然后,读出来就按 a 作为标志就这么简单
同时插入两张表是不行的 插入表: select a,b,c,d into table1 from table select a, f, g into table2 from table 读出表: select m.a, m.b, m.c, m.d ,n.f, n.g from table1 as m, table2 as n where m.a = n.a
我要把 a,b,c,d 插入table1
把 a,f,g 插入table2然后,读出来就按 a 作为标志就这么简单
插入表:
select a,b,c,d into table1 from table
select a, f, g into table2 from table
读出表:
select m.a, m.b, m.c, m.d ,n.f, n.g from table1 as m, table2 as n where
m.a = n.a