title: Using linq to query two sorted lists
body: <p>I am pulling in a hotfix list with wmi into a sortedlist.  I then have the cluster fixes in another list built from <a href="http://support.microsoft.com/kb/2545685" rel="nofollow">http://support.microsoft.com/kb/2545685</a></p>
  
  <pre><code>Dim p_Windows2008R2sp1ClusterFixes As New sortedList
  p_Windows2008R2sp1ClusterFixes("2525380") = ""
  p_Windows2008R2sp1ClusterFixes("2446607") = ""
  p_Windows2008R2sp1ClusterFixes("2531907") = ""
  p_Windows2008R2sp1ClusterFixes("2550886") = ""
  p_Windows2008R2sp1ClusterFixes("2552040") = ""
  p_Windows2008R2sp1ClusterFixes("2520235") = ""
  p_Windows2008R2sp1ClusterFixes("2494162") = ""
  p_Windows2008R2sp1ClusterFixes("2524478") = ""
  p_Windows2008R2sp1ClusterFixes("2494162") = ""
  
  Dim hotfixArray As String() = {981391, 981392, 977236, 981111, 977238, 977239 }
  For i As Integer = 0 To hotfixArray.Length - 1
            slMissingList(hotfixArray(i)) = hotfixArray(i)
  Next
  </code></pre>
  
  <p>I want to be able to do an inner join to see what fixes are installed and a left outer join using linq to tell me what fixes are not installed. 
  there are several hundred fixes on 1 to 16 machines.  I need to be able to see what fixes are each machine.</p>