SELECT
    id,
    a,
    b
FROM prefix_2014.mytable
UNION ALL
SELECT
    id,
    a,
    b
FROM prefix_2013.mytable
UNION ALL
    id,
    a,
    b
FROM prefix_2012.mytable