INSERT INTO t1
(col1, col2, col2)
SELECT col1 as columnA, col2 as columnB
FROM t2
WHERE col1 = 'abcde'