I am trying to join two datatables with linq
The query is
out_dt = (From row1 in dt1, row2 in dt2
where row1("id").ToString = row2("id").ToString
Select row1).CopyToDatatable
Except now I realize that I also need a column from table dt2
So, how do I modify the select statment to get a row1, and a column from dt2, say row2(“col2”)
I can do it with a loop after the query but the table has thousands of columns and the query already lasts a long time to run so I would like to do this in one step
Much obliged