 SQL prefix column names with the table they came from

ID: sql-prefix-column-names-with-the-table-they-came-from

 Top articles  Latest articles + New article in topic

SQL prefix column names with the table they came from by

Ciro Santilli 37  Updated 2025-07-01  +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

 New to topics? Read the docs here!