INSERT INTO TABLE2 (COLUMN1, COLUMN2, COLUMN3)
SELECT COLUMN1, COLUMN2, COLUMN3
FROM TABLE1 WHERE COLUMN4='FOOBAR'