title: How do I solve syntax error in from clause?
body: <pre><code>string query = "select a.Name,a.Add from GroupDetails a join General b on a.ID=b.Id where b.AccCode='" + label1.text + "'";
  OleDbCommand cmd = new OleDbCommand(query, con);
  OleDbDataAdapter daName = new OleDbDataAdapter(cmd);
  
  OleDbDataReader dr = cmd.ExecuteReader();
  while (dr.Read())
  {
  
      txtName.Text = dr["a.Name"].ToString();
      txtAdd.Text = dr["a.Add"].ToString();
  }
  </code></pre>
  
  <p>There shows an exception </p>
  
  <blockquote>
    <p>Syntax error in FROM clause</p>
  </blockquote>