title: c# Selecting data from 2 different tables in ms access
body: <p>I want to select data from 2 different tables. I am using MS access and I want to display the data in combo boxes. What is the proper way to do this i've tried:</p>
  
  <pre><code>string query = "select ProductName, BranchID from Product, Branch";
  
  
          command.CommandText = query;
  
  
          OleDbDataReader reader = command.ExecuteReader();
  
  
  
          while (reader.Read())
          {
  
           comboBox1.Items.Add(reader["BranchID"].ToString());
              comboBox2.Items.Add(reader["ProductName"].ToString());
  </code></pre>