SQL Join Question

Question

I will be joining multiple tables all with the same columns, is there anyway so setup the query so the specific table prefix is not needed?

Or am I trapped into using select a._id,b._id....z._id ?

Answer 1

No. If the columns have the same name, then the database software needs to be able to distinquish between them somehow.