var allRows =
from
dataTable1Rows in dataTable1.AsEnumerable()
join
dataTable2Rows in dataTable2.AsEnumerable()
on
dataTable1Rows.Field<int>("ID") equals dataTable2Rows.Field<int>("ID")
select
dataTable2Rows;
DataTable joinedDataTable = allRows.CopyToDataTable();
and this joinedDataTable you can bind to rdlc , if you want to do it at c# side , otherwise if you want a sql server query a simple join between two tables should work
SELECT table1.ID ,table1.Name, table2.Skill, table2.Proficiency
FROM datatable1 table1
INNER JOIN datatable2 table2 ON table1.ID = table2.ID where table1.ID='R1'
Hope this helps
Regards,
Harika Kakkireni