<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp;I have 2 databases named DB1 and DB2 running in same instance of DB2 server installation in AIX. I would like to join table1 of DB1 and table2 of DB2 in same query. so query will looks like,<br />
<br />
select DB1.table1.fieldname1,DB2.<wbr />table2.fie<wbr />ldname2 from DB1.tablename1, DB2.tablename2<br />
<br />
Thanks,<br />
Mohan<br />
<br />

</div>
</div>


Hi,
 I have 2 databases named DB1 and DB2 running in same instance of DB2 server installation in AIX. I would like to join table1 of DB1 and table2 of DB2 in same query. so query will looks like,

select DB1.table1.fieldname1,DB2.table2.fieldname2 from DB1.tablename1, DB2.tablename2

Thanks,
Mohan



Using multiple databases in DB2 query

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.