Hey Kevin,
The order of the fields in the UNION is dependant on the ordering in the query.
If I'm understanding correctly, you just need something like this:
SELECT ID, NOM, PRENOM
FROM tableA
UNION ALL
SELECT ID, PRENOM, NOM
FROM tableB
Become a Viz Whiz on the Forums! Support the Community and master Tableau.