Ah, yes... 
You are right. Ok, last thing:
Is there a way to give each column of a table a different label for a column than its technical name?
Background: the frontend-table is displaying the value it gets from a union with another table.
SELECT e.name, o.office_location
FROM employees e
LEFT OUTER JOIN office o ON o.id = e.office_id;
If I update the office_location I want to update e.office_id and not office_location, which is in the table office, which is only referenced.