INSERT INTO A (col1,col2,col3) SELECT fld1,fld2,fld3 FROM B;