Select inside insert query

INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;

#INSERT INTO table2 (column1, column2, column3, ...)
#SELECT column1, column2, column3, ...
#FROM table1
#WHERE condition;

Similar codes

1 vote266 views1 answer
Declare table variable
SQL
33 votes288 views6 answers
Sql delete
SQL
0 vote275 views1 answer
Display all node label neo4j
SQL
0 vote247 views1 answer
Default column value in sql same as other column
SQL
0 vote281 views1 answer
SQL check if record exist
SQL
16 votes263 views3 answers
Tsql rename column name
SQL
2 votes260 views1 answer
Creating a view SQL
SQL
1 vote265 views1 answer
Oracle drop chain step
SQL
1 vote250 views1 answer
Sql select contem uma palavra
SQL
0 vote258 views1 answer
Django mssql backend
SQL