 SQL prefix column names with the table they came from

 New to topics? Read the documentation here!

 Top articles  Latest articles + New article in topic

SQL prefix column names with the table they came from by

Ciro Santilli 35  Updated 2025-01-10  +Created 1970-01-01

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

 Read the full article