title: Vb.net Updating Datagrid View with data from multiple Datatables
body: <p>I have two Data tables and they have Asset mapping (Asset ID's &amp; EmpID's tagged to each asset) and Associate Details (EmpID of all associates in a company). Now I want to have a third Data table built, which shows the assets that are not tagged to a valid associate, i.e., the EmpID in First Data table should not be present in Second Data table.</p>
  
  <p>In SQL terms it will be:</p>
  
  <pre><code>Select AssetID, UserID from AssetMapping
  Where UserID Not In (Select EmpID from AssociateDetail)
  </code></pre>
  
  <p>How can I accomplish the task of getting the result in a third data table (which I need to show in a data grid view later)?</p>