title: Merging 2 data tables in vb.net
body: <p>I have 2 DataTables in vb.net.  Each is populated from it's own stored procedure.  Table A contains a project number in the first column.  Table B also contains the project number in the first column.  Table A could have many records that have the same project number, but Table B will always have just one record in it per project number.  I would like to append the data from Table B to every matching record in Table A.  How would I do this?</p>
  
  <p><strong>Table A could look like this:</strong></p>
  
  <p>PROJECT#, QUANTITY</p>
  
  <p>12345, 100</p>
  
  <p>12345, 200</p>
  
  <p>12345, 300</p>
  
  <p><strong>Table B could look like this:</strong></p>
  
  <p>PROJECT#, CUSTOMER</p>
  
  <p>12345, ABC Inc.</p>
  
  <p><strong>I would like to merge the two to create something like this:</strong></p>
  
  <p>PROJECT#, QUANTITY, CUSTOMER</p>
  
  <p>12345, 100, ABC Inc.</p>
  
  <p>12345, 200, ABC Inc.</p>
  
  <p>12345, 300, ABC Inc.</p>
  
  <p>Please help!</p>