In the database I have a number of tables with the same column name. for example Employer.FirstName, Staff.FirstName, Person.firstName etc.
I'm doing a full outer join and want to rename these without specifying the columns.
So it's
Select employer.*, staff.*, person.* from employer full...