I have a requirement wherein i have to use two database (oracle and db2) to display the data on the report.
in oracle i have
In db2 i have
documents (this will be more than one documents for a account)
my report should be showing documents for each account
acctnum acctname recdate documents
123 test 5/1/2013 document a
I am using sql server 2005. please suggest how i can achieve it