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
Recdate
acctnum
acctname
acctID
In db2 i have
acctID
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
document b
document c
I am using sql server 2005. please suggest how i can achieve it