insert into table1 select * from table2 where 注意表结构是否相同不相同就要写字段名(在*处)。
insert into table select * from table2 where .... insert inot table('','','') select '','',.. from table2 where .... 数据库是sql server的肯定行
可我用的是ACESS数据库,,其中字段出错了,,
sql.Add('insert into TB_STPM(col_num,col_name,col_birthday,col_sex,col_bornplace,col_charaters,col_readytime) select col_num,col_name,col_birthday,col_sex,col_bornplace,col_charaters,col_readytime from TB_TPM where col_state ');
注意表结构是否相同不相同就要写字段名(在*处)。
insert inot table('','','') select '','',.. from table2 where ....
数据库是sql server的肯定行