If the table schemas are different and a direct UNION won't work - I would suggest:

SELECT ( SELECT field1

, field2

...

Can we assume that both tables are identical except for the output node name? The XML AUTO (or PATH) and UNION would work that way - but if the...