<div>
<br />
The technique is the same regardless, simply add the database parameter to the four part object naming convention.<br />
<br />
server.database.owner.name<wbr />.<br />
<br />
So you see, if you have set up linked servers, you can easily join tables on different servers in the same way!! (cool eh?)<br />
<br />
One caveate when going across databases (or servers!) is that you could encounter collation issues, if the databases have different collations.<br />
<br />
One way around this is to use the &quot;collate database_default&quot; directive right after each join expression.<br />
<br />
Cheers,
</div>



The technique is the same regardless, simply add the database parameter to the four part object naming convention.

server.database.owner.name.

So you see, if you have set up linked servers, you can easily join tables on different servers in the same way!! (cool eh?)

One caveate when going across databases (or servers!) is that you could encounter collation issues, if the databases have different collations.

One way around this is to use the "collate database_default" directive right after each join expression.

Cheers,

<div>
<div class="content wysiwyg-content">
Can someone show me how too join from 2 different databases as opposed too 2 different tables in one database<br />
<br />
The databases i want to join are dbo.tblfall_Details on database A to tblEnd_Details on Database B<br />
The field i want to join is tblFall_Details.aby to tblEnd_Details.userID <br />
<br />
Nb userid is a primary key, whereas aby isnt!<br />
<br />
Thanks in advance
</div>
</div>


Can someone show me how too join from 2 different databases as opposed too 2 different tables in one database

The databases i want to join are dbo.tblfall_Details on database A to tblEnd_Details on Database B
The field i want to join is tblFall_Details.aby to tblEnd_Details.userID 

Nb userid is a primary key, whereas aby isnt!

Thanks in advance

Joins

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.