new to sql..plz help
Insert into a table , values for this table will be fetching from another table
JamesK
#2
INSERT INTO ATable
(col1, col2, col3)
SELECT
colA, colB, colC
FROM
AnotherTable
-- WHERE
-- some filtering condition if you have any