how to add a column from another table in a query for one table in SQL server code example
Example: insert select
INSERT INTO table2
SELECT * FROM table1
WHERE condition;
INSERT INTO table2
SELECT * FROM table1
WHERE condition;