SQL: INSERT Statement - TechOnTheNet.com

Example - Using SELECT statement You can also create more complicated SQL INSERT statements using SELECT statement. For example: INSERT INTO suppliers (supplier_id, supplier_name) SELECT account_no, name FROM customers WHERE city = 'Newark';

www.techonthenet.com