You already got the UNION ALL solution. I presume that if the table does not fit in memory it can be slow. This is why I asked about the size.

Another...

Hi,

So, lets see if I understand: You need a query that does this transformation for you. Then, you would like to put together a query execute an INSERT INTO SELECT...