using 3 tables to create a new table

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:

Code:

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.

Code:

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