Import data from Table A into Table B

[DaPi]

Insert into tableB
select whatever from tableA
where . . . . . .

. . . but I've a sneeking feeling that's not what you want.