No need to wrap select statement in parentheses.

You need to query like this and it will work:

INSERT INTO tableA (uniqueColA, colB, colC)
SELECT uniqueColA, colB, colC 
FROM tableB 
WHERE uniqueColA IN (1,2)