<div>
Thank you all for the replies. &nbsp;I will go the route Wayne88 alluded to. &nbsp;Fernando Soto, I have never used your idea but I appreciate your contribution and will put it in my toolbox for future use.<br />
<br />
Thanks,<br />
jimbo99999
</div>


Thank you all for the replies.  I will go the route Wayne88 alluded to.  Fernando Soto, I have never used your idea but I appreciate your contribution and will put it in my toolbox for future use.

Thanks,
jimbo99999

<div>
<div class="content wysiwyg-content">
Good Day Experts!<br />
<br />
I have 2 lists of AccountNumbers. &nbsp;I am looking for duplicate product numbers across all the accounts. &nbsp;Here are my 2 lists and a little summary of what I am doing: <br />
<br />
1 &nbsp; &nbsp; 1<br />
2 &nbsp; &nbsp; 2<br />
4 &nbsp; &nbsp; 4 &nbsp; &nbsp; <br />
5 &nbsp; &nbsp; 5<br />
6 &nbsp; &nbsp; 6<br />
<br />
I loop through first list comparing to all in the second list. &nbsp;Problem I have is...say I find a duplicate in Account 1 and 2...then I also get the same record when on Account 2 and comparing to Account 1. &nbsp;<br />
<br />
Do you have any ideas on hos I can better do this compare to eliminate the extra records?<br />
<br />
Thansk,<br />
jimbo99999
</div>
</div>


Good Day Experts!

I have 2 lists of AccountNumbers.  I am looking for duplicate product numbers across all the accounts.  Here are my 2 lists and a little summary of what I am doing: 

1     1
2     2
4     4     
5     5
6     6

I loop through first list comparing to all in the second list.  Problem I have is...say I find a duplicate in Account 1 and 2...then I also get the same record when on Account 2 and comparing to Account 1.  

Do you have any ideas on hos I can better do this compare to eliminate the extra records?

Thansk,
jimbo99999

VB.Net - Comparing Two DataTables

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.