title: joining two tables to be bound on a gridview
body: <p>I was getting confused on how to build the SQL query when it come to joining two tables so that I could bind them later to a gridview.</p>
  
  <p>Basically I have two tables,</p>
  
  <pre><code>tablename: family
   __________________________
  |Status |lastName|firstName|
  |-------|--------|---------|
  |1      |11      |111      |
  |2      |22      |222      |
  |3      |33      |333      |
  ''''''''''''''''''''''''''''
              +
  
  tablename: familyStatus
   _____________________
  |id        | Notes    |
  |----------|----------|
  |1         | 1111     |
  |2         | 2222     |
  |3         | 3333     |
  '''''''''''''''''''''''
  
             =
  
  Joined-tables: family+familyStatus [this is what i want]
   ____________________________
  |firstName | lastName |Notes |
  |----------|----------|------|
  |111       | 11       |1111  |
  |222       | 22       |2222  |
  |333       | 33       |3333  |
  ''''''''''''''''''''''''''''''
  </code></pre>
  
  <p>what your seeing here is that the <strong>Status</strong> from table <strong>family</strong> and <strong>id</strong> from <strong>familyStatus</strong> is the same key, status and id will be hidden on the gridview.</p>
  
  <pre><code>Lets just assume for now that this is how i get the family table.
  
  SELECT Status, firstName, lastName
  FROM family
  WHERE firstName= @fN
  AND lastName = @lN
  </code></pre>
  
  <p>What do I need to add here so that the Notes from family table also gets joined?</p>