I have two tables and I need to compare them. I need to build a third table that contains the data in table1 that was not found in table 2. I was able to figure out how to find the ones that match but I can’t figure out how to find the ones that don’t match:
(From da In dtfull.AsEnumerable
Join db In dtpart.AsEnumerable
On da(0).ToString.Trim Equals db(0).ToString.Trim
Do I have to somehow change the equals to not equals?
Note: both tables only have one column each with no name.