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 vote132 views1 answer
How to select random rows from table
SQL
0 vote131 views1 answer
If null don't update
SQL
0 vote132 views1 answer
Show database not empty tables postgres
SQL
1 vote135 views1 answer
Oracle sql listagg
SQL
4 votes134 views2 answers
Mysql select where starts with
SQL
1 vote133 views1 answer
Mysql how to reset primary key
SQL
4 votes139 views2 answers
Oracle set date format
SQL
0 vote152 views1 answer
Hotw to alter lengh character vayng postgres
SQL
5 votes132 views2 answers
Postgres update with if condition query
SQL
3 votes145 views5 answers
Sql select
SQL