How can I join information from different datasets?

Question

I want to know how to join information that is in 2 different datasets into a single table.
Thanks
P.S. Also having problems with data driven subscription, it simply won't connect to the database with subscribers, always getting the logon error.

Answer 1

Probably not the answer you're looking for, but this functionality isn't supported in either 2000 or 2005 -- You'll basically have to do the (join) work inside a SQL sproc/view and then pull the results into a single dataset

Sorry...

Answer 2

Thank you for your answer.
P.S. Do you have any guidelines for me for the second problem? Also posted it in another thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124613&SiteID=1