OurBigBook
About
$
Donate
Sign in
+
Sign up
by
Ciro Santilli
(
@cirosantilli,
34
)
SQL prefix column names with the table they came from
...
Database
Relational database
Relational database management system
SQL
SQL keyword
JOIN (SQL)
Like
(0)
0 By others
on same topic
0 Discussions
Updated
2024-12-15
+
Created
1970-01-01
See my version
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)
SQL keyword
SQL
Relational database management system
Relational database
Database
Software
Computer
Information technology
Area of technology
Technology
Home
View article source
Discussion
(0)
Subscribe (1)
+
New discussion
There are no discussions about this article yet.
Articles by others on the same topic
(0)
There are currently no matching articles.
See all articles in the same topic
+
Create my own version