how to join two table different database?

Question

in have database

1. test 2. test2

database test

table1 field [ id ,password ,name , lastname ]

database test2

table2 field [ id]

how to select test and test2 where table1 have id in test2.table2.id

in c# with sql server 2005

Answer 1

Have you tried it? You just write the database name test2.dbo.tblFoo, though you may need to declare an alias (just write a word after writing the actual name). And the account will obviously need permissions to both DBs.

Answer 2

SELECT /* stuff */
FROM table1 t1
JOIN table2 t2 ON t1.id = t2.id

Answer 3

I can use some functionality in ORM, Hibernate Shards for example.