title: Loading DataTable with multiple tables select query
body: <p>I never used select queries with multiple tables involved before and now when I do, I'm having troubles with getting the information from the <code>DataTable</code>.</p>
  
  <p>I have this query:</p>
  
  <pre><code>SELECT * 
  FROM [Usergroups], [Groups] 
  WHERE [Usergroups.UserID] = @name 
    AND [Groups.GroupID] = [Usergroups.GroupID]
  </code></pre>
  
  <p>And this is how I get the returned values into a DataTable:</p>
  
  <pre><code>DataTable groupsTable = new DataTable();
  groupsTable.Load(sqlCmd.ExecuteReader());
  </code></pre>
  
  <p>Now, how can I specify my <code>DataTable</code> from which table I want to take rows from? For example, this is what I did before multiple tables where involved:</p>
  
  <pre><code>string groupName = groupsTable.Rows[0]["Name"];
  </code></pre>
  
  <p>I could not find any resource with such information, but I know it's a basic question. Thanks in advance.</p>