Wednesday, October 29, 2008

SQL: Insert from another table

INSERT INTO Table1 (a, b)     
SELECT c, d     
FROM Table2     
WHERE c = 'something'