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

Show body

SQL prefix column names with the table they came from by

Ciro Santilli 34 Updated 2024-10-28 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