title: Joining Data from Two Datasets
body: <p>All I really want to do is a join. Table 1 and Table 2 both have a number that would link the two together. I want to join two fields from Table 2 onto Table 1. I need to have two datasets because there are two different connections being made.</p>
  
  <p>I want to push this onto a DataGridView, which only allows a single datasource. So I'm thinking I would need to make a temp table somehow, but since I'm pulling from two different datasets I don't know if that's possible.</p>
  
  <p>I saw this: <a href="https://stackoverflow.com/questions/2868335/combine-multiple-dataset-columns-to-one-dataset">Combine multiple dataset columns to one dataset</a> but it doesn't seem to be working for me.</p>