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

0 vote153 views1 answer
What is ssrs and ssis in sql server
SQL
1 vote174 views1 answer
Postgresql can you have null foreign key
SQL
8 votes182 views2 answers
Sqlsrv default port
SQL
1 vote111 views1 answer
Python escape string for sql
SQL
0 vote141 views1 answer
Oracle list chain steps
SQL
0 vote175 views1 answer
How convert into in in sql query
SQL
6 votes155 views1 answer
Oracle desc table primary key
SQL
0 vote181 views1 answer
Sql server insert inner join
SQL
0 vote162 views2 answers
Temp Space
SQL
22 votes170 views3 answers
Year format in date mysql
SQL