I’ve been through the forum and I’ve managed to find an inner join solution which is working great for me so far.
But, at this moment, I need to perfom a full inner join - meaning I need columns from table A as well as columns from table B which satifies the criteria.
This is my code:
(From a In MarginMulti.AsEnumerable() Join b In MarginEdam.AsEnumerable() On a(ColMulti).ToString() Equals b(ColEdam).ToString() Select a).CopytoDataTable()
Note the last row …Select a).CopytoDataTable(). I need to select “a” AND “b”. I’ve tried comma, “AND”, space, but nothing works so far. Any tips?