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.