求表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
