insert into tableB (<field_list>) SELECT <field_list> FROM tableA
<br /> insert into tableB<br /> select col1,col2,col3,'' from tableA<br />
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)