The field “costumer-ID” on the “order table” is a foreign key from “costumer table”, field “costumer-ID”. I managed the consumer name to be shown in the “order table” field “costumer-ID” instead of the number. But when I run a union query using field “costumer ID” from “order table, only the ID number of the customer is shown. How can make the costumer name to be shown instead?