SQL prefix column names with the table they came from

It is mind blowing that this is not possible... the only way to avoid ambiguity in JOINs with column name conflicts is to give aliases to each column...

stackoverflow.com/questions/329931/sql-select-join-is-it-possible-to-prefix-all-columns-as-prefix
stackoverflow.com/questions/13153344/in-a-join-how-to-prefix-all-column-names-with-the-table-it-came-from

 Ancestors (12)

JOIN
SQL keyword
SQL
Relational database management system
Relational database
Database
Software
Computer
Information technology
Area of technology
Technology
 Home