SELECT column ranges using wildcards

[John Maxwell]

I have this simple question, let's say you select data from 2 different tables and those two tables both have a field named 'ID'.

Is there a way to get all the field of the two tables exept the second 'ID' field but using wildcard, for exemple to illustrate the concept:

SELECT table1.*, (table2.* AFTER table2.ID) WHERE year > '2004';

I know this command doesnt work but is there any way to do this?

Thanks

John Maxwell