Is this possible:

1. Joining tables in two databases in one server?

1.1 What connection string shall i use?
2. Joining tables in two databases in different server?

2.1 What connection string shall i use?