OurBigBook
About
$
Donate
Sign in
Sign up
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
Show body
Body
0
SQL prefix column names with the table they came from
by
Ciro Santilli
37
Updated
2025-07-16
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
Total
articles
:
1
New to
topics
?
Read the docs here!