<div>
Yes you use select [column1, column2] from table1, table2 where table1.column1 = table2.column2<br />
<br />
Below is a link with some detail for you<br />
<br />
<a href="http://articles.techrepublic.com.com/5100-10878_11-1050307.html" rel="ugc">http://articles.techrepublic.com.com/5100-10878_11-1050307.html</a><br />

</div>


Yes you use select [column1, column2] from table1, table2 where table1.column1 = table2.column2

Below is a link with some detail for you

http://articles.techrepublic.com.com/5100-10878_11-1050307.html [http://articles.techrepublic.com.com/5100-10878_11-1050307.html]


<div>
Thanks dacasey, but what I am looking for is mutiple data bases, not multiple tables. I know how to do this in MSSQL, but am looking for a way to do this in Firbird 1.5
</div>


Thanks dacasey, but what I am looking for is mutiple data bases, not multiple tables. I know how to do this in MSSQL, but am looking for a way to do this in Firbird 1.5

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Is it possible to query multiple databases, joining the data on the specific common fields, and return a result set of the combined data, and if so, how can this be done.
</div>
</div>


Is it possible to query multiple databases, joining the data on the specific common fields, and return a result set of the combined data, and if so, how can this be done.

Cross database queries in Firebird 1.5

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.