ErnesTech | SQL: How to Insert INTO values from another table into another table

Q: ErnesTech | SQL: How to Insert INTO values from another table into another table

If you want to insert into a table value from another table or from CTE, make sure that you define columns to insert into a table then select * from cte/table. If you want to select into NEWTABLE from another table, there is no need to define columns to insert into.

Question

Accepted Answer

If you want to&#xA0;insert into a table value from another table or from CTE, make sure that you define columns to insert into a table then select * from cte/table. If you want to select into NEWTABLE from another table, there is no need to define columns to insert into.