I suppose I should have named things differently but is there a way to
join two tables with a bunch of identical column names and rather than
explicitly alias each column just use some sort of wildcard like:
SELECT tablename.* AS alias.*
OR do I have to name each column like:
columnname as alias
Thanks much.
