<div>
SELECT datasource1.customer.field<wbr />1,datasour<wbr />ce1.custom<wbr />er.field2,<wbr />datasource<wbr />1.customer<wbr />.field3,da<wbr />tasource1.<wbr />customer.f<wbr />ield4*, datasource2.payments *<br />
FROM datasource1.customer INNER JOIN Orders ON datasource1.customerCustom<wbr />erNo = <br />
datasource2.payments..Cust<wbr />omerNO
</div>


SELECT datasource1.customer.field1,datasource1.customer.field2,datasource1.customer.field3,datasource1.customer.field4*, datasource2.payments *
FROM datasource1.customer INNER JOIN Orders ON datasource1.customerCustomerNo =
datasource2.payments..CustomerNO

<div>
Thanks for the split. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the split.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
I have two databases - same server <br />
I need to create a join of datasource1.customer and datasource2.payments - joined on an account number.<br />
How would I do this .
</div>
</div>


I have two databases - same server 
I need to create a join of datasource1.customer and datasource2.payments - joined on an account number.
How would I do this .

join two tables from two different databases

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.