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?
..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? :wave:
Thanks
Sibby