<div>
Thank you. Works perfectly.
</div>


<div>
<div class="content wysiwyg-content">
<br />
I have two databases, Database1 and Database2 on the same server.<br />
<br />
I need to select a column form Database1 and a column from Database2<br />
<br />
The query is being built in Database1<br />
<br />
SELECT <br />
<br />
ColumnName FROM Database2.TableName <br />
<br />
error:<br />
<br />
Invalid object name 'Database2'<br />
<br />
What is the correct syntax ?<br />
<br />
Thanks,<br />
&nbsp;
</div>
</div>



I have two databases, Database1 and Database2 on the same server.

I need to select a column form Database1 and a column from Database2

The query is being built in Database1

SELECT 

ColumnName FROM Database2.TableName 

error:

Invalid object name 'Database2'

What is the correct syntax ?

Thanks,
 

How to specify a select from a different database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.