日期:2014-05-17  浏览次数:20408 次

求表B数据导入表A 谢谢
表AA
USER,DATE,MK001,MK002,MK003,UDF001
001,20121225,201201,2012,66011,002
002,20121223,201201,2012,68012,002
001,20121226,201202,2012,68012,003
表BB
MK001,MK002
201301,2013
201302,2013
...
...
求如何将表BB的数据增加到表AA里  (表BB没有的字段让其为空) 谢谢
 AA
USER,DATE,MK001,MK002,MK003,UDF001
001,20121225,201201,2012,66011,002
002,20121223,201201,2012,68012,002
001,20121226,201202,2012,68012,003
   ,        ,201301,2013,     ,   
   ,        ,201302,2013,     ,

------解决方案--------------------
insert into aa
select null,null,MK001,MK002,null,null from bb