Full Inner Join - Datables

datatable

#1

Hi guys,

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?

Regards,
Felipe


#2

Anyone?