OurBigBook
About
$
Donate
Sign in
+
Sign up
by
Ciro Santilli
(
@cirosantilli,
35
)
SQL prefix column names with the table they came from
...
Type of database
Relational database
Relational database management system
SQL
SQL keyword
JOIN (SQL)
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
(13)
JOIN (SQL)
SQL keyword
SQL
Relational database management system
Relational database
Type of 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