SQL select join: is it possible to prefix all columns as ‘prefix.*’?

It seems the answer to your question is no, however one hack you can use is to assign a dummy column to separate each new table. This works especially well if you’re looping through a result set for a list of columns in a scripting language such as Python or PHP.

SELECT '' as table1_dummy, table1.*, '' as table2_dummy, table2.*, '' as table3_dummy, table3.* FROM table1
JOIN table2 ON table2.table1id = table1.id
JOIN table3 ON table3.table1id = table1.id

I realize this doesn’t answer your question exactly, but if you’re a coder this is a great way to separate tables with duplicate column names. Hope this helps somebody.

Leave a Comment