new to sql..plz help
INSERT INTO ATable
(col1, col2, col3)
SELECT
colA, colB, colC
FROM
AnotherTable
-- WHERE
-- some filtering condition if you have any
dennis, when posting it is a good idea to state your problem again in the body of the post.
Also examples of data and table layouts are helpful. That said @JamesK did a good job of showing the general overview.