select inside insert query

Solutions on MaxInterview for select inside insert query by the best coders in the world

showing results for - "select inside insert query"
Bryant
13 Oct 2019
1INSERT INTO Customers (CustomerName, City, Country)
2SELECT SupplierName, City, Country FROM Suppliers;
3
4#INSERT INTO table2 (column1, column2, column3, ...)
5#SELECT column1, column2, column3, ...
6#FROM table1
7#WHERE condition;