using 3 tables to create a new table

[Wizz]

Hi,
I need to create a table with 2 columns (Name and LastDate). Row amount depend on the source tables. I get various tables from the system using the following line:


DataSet myDS = new DataSet();
myDS = DataObjects["QueryResult"] as System.Data.DataSet;



The "Name" values are in one table; the "LastDate" values are in a different table and there is a third table wich has a code/index to relate both.

I need help; I'm SOOO LOST in C#. I'm a self thaught VBA coder but I'm strugeling with this virtual tables/grids/datsets, etc.

I searched the net, and found the following tools.

Dictionary<string, string> key2count = new Dictionary<string, string>();
foreach (KeyValuePair<string, string> kv in key2count)

Unfortunatelly they aint working for me.

I really appreciate any help (code or further documentations links)

P.S. I'm attaching an excel document with a sample of the source tables and sample of the desired output.

Thanks

[JonnyPoet]

...
P.S. I'm attaching an excel document with a sample of the source tables and sample of the desired output.

ThanksThis doesn't really look for me to be a problem of C# , but more that looks me to be a problem of a correct sql query