When SELECTing from 2 or more tables with identical field names like this:
SELECT * ;
FROM taz2005 a;
inner JOIN taz2010 c ON a.taz = c.taz
the result field names have an "_a" appended to them for the first table and a "_b" appended for the second table. I would like them to come up with "_2005" appended for the first table and "_2010" appended for the second table. Is there an easy way to do this without writing a ton of code to parse and rename the fields?
Secondly, I'd like the fields from the two tables to be collated so like fields would appear next to each other like this:
HH_2005, HH_2010, etc.
Same question, is there an easy way to do this? I know about SET FIELDS, but the issue here is each table has 40+ fields and we don't know how many, or which, tables may be joined in advance. I am trying to move my people out of excel and into a database but the complexity is daunting to them.
Thanks for any thoughts on this.