Need Help creating a Dataset table as a result of two other Dataset Tables

[astralvoid]

I am writing an application in VB.NET in which I have the results of 2 queries from different databases stored within a Dataset as 2 different tables. My problem is that I need to 'Query' both of these tables to create a new result set within the same Dataset as a 3rd table.


Can anyone offer to point me in the right direction to accomplish this?

[Sibby]

..but can anyone answer this? I came across it in a search and I need to do the exact same thing. As much as I've read you can't do full blown SQL statements on a dataset other than simple filtering on a single table in a dataset, which isn't going to help me. I need to be able to return all rows where "keyfield" is equal on both "table1" and "table2". If you can't use SQL, how do you do this? Anyone lend a hand? Edneeis?

Thanks

Sibby