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

3 votes133 views1 answer
Sql server version query
SQL
0 vote139 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote92 views1 answer
Check if due date is less than todays date sql
SQL
6 votes142 views3 answers
Sql select last id
SQL
2 votes136 views1 answer
Enum in SQL Server
SQL
23 votes138 views4 answers
How to uninstall postgresql in ubuntu
SQL
5 votes128 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote134 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote158 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote136 views1 answer
Convert uniqueidentifier to varchar in sql
SQL