how to fetch a table column of same name of more than 4 different database in sql server 2008r2???
Database
2
Posts
2
Posters
0
Views
1
Watching
-
how to fetch a table column of same name of more than 4 different database in sql server 2008r2???
-
how to fetch a table column of same name of more than 4 different database in sql server 2008r2???
When you create a complex SQL query with a large number of joins you may get into the problem of same column names in different tables. To assign a name of your choice to any of the returned columns you may use the format of
table.field as my_field_name
It is irrelevant from where the tables are as long as you can link to those databases - do you have problem there?
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
