Full Inner Join - Datables

Help
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

1 Like
2

Anyone?

3

Hello,

you can use the result of two inner joins as datatables and merge them

try this, (im not sure of this but just an Idea)
(From a In MarginMulti.AsEnumerable() 
 Join b In  MarginEdam.AsEnumerable() 
  On a(ColMulti).ToString() Equals b(ColEdam).ToString()
  Select a).CopytoDataTable()
.merge(
(From a In MarginMulti.AsEnumerable() 
 Join b In  MarginEdam.AsEnumerable() 
  On a(ColMulti).ToString() Equals b(ColEdam).ToString()
  Select b).CopytoDataTable()
)

Thanks,
Meg

1 Like