can a select statement bring the result of columns data from tables of different database?

Question

i mean if i can retrieve data from different database's table's column then it will be useful

Answer 1

You can find some information here
https://stackoverflow.com/questions/6944373/query-against-two-tables-in-separate-databases-on-the-same-server