How can I join information from different datasets?

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.

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...

|||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