Hi DBAs,



I've joined LazyDBA once again.



I have two different databases on two different locations and I want to
query data from both the database servers.



Select * from db1.tab1 tab1, db2.tab2 tab2

Where tab1.col1 = tab2.col1;





So, kindly advise me the better way to achieve it.



Any help would be highly appreciated.



Thanks and Regards,

Jitendra Kumar Prajapati











============================================================================================================================

Tech Mahindra, formerly Mahindra-British Telecom.

Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

DB2 & UDB email list listserv db2-l LazyDBA home page