How to get the name in a mysql view?

Hi all,

I have a mysql query (UNION of 4 tables). I display this view to the user. How do I display the name and not the ID to the user? I mean this view has no "relations" (fk or whatsoever) so how do I access the name? Eg:


















In my view lets say:

SELECT idA FROM TableB WHERE common=0;


SELECT idA FROM TableC WHERE common=0;

When I show this view to the user, how do I display "name" from tableA (not idA)?