title: Incorrect syntax near the keyword
body: <p>My code seems correct. But when I add the <code>Group</code> keyword in the query it produces a message:</p>
  
  <blockquote>
    <p><em>Incorrect syntax near the keyword 'Group'</em></p>
  </blockquote>
  
  <p>but when I remove the <code>Group</code> keyword the program runs successfully.</p>
  
  <pre><code>private void CSRMaintReviewer_Load(object sender, EventArgs e)
      {
          this.MaintReviewertbl.DataSource = null;
          SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["csrapps"].ConnectionString);
  
          conn.Open();
          SqlCommand cmd = new SqlCommand();
          cmd.Connection = conn;
          cmd.CommandType = CommandType.Text;
          cmd.CommandText = "select " +
                            "EmailID_Reviewer, " +
                            "Reviewer_Name, " +
                            "Reviewer_Email, " +
                            "EmailID_TeamLead, " +
                            "TeamLead_Name, " +
                            "TeamLead_Email, " +
                            "Site, " +
                            "Business_Unit, " +
                            "Group, " +
                            "Station, " +
                            "Pkg_Department, " +
                            "Region, " +
                            "Account, " +
                            "Key_Field, " +
                            "EmailID_SiteManager, " +
                            "SiteManager_Name, " +
                            "SiteManager_Email, " +
                            "EmailID_SiteDirector, " +
                            "SiteDirector_Name, " +
                            "SiteDirector_Email, " +
                            "EmailID_President, " +
                            "President_Name, " +
                            "President_Email, " +
                            "Customer, " +
                            "Flag, " +
                            "CreatedBy, " +
                            "DateCreated, " +
                            "LastUpdatedBy, " +
                            "DateUpdated " +
                            "from dbo.tblCSRMaintReviewer ";
  
          try
          {
              SqlDataReader reader = null;
              reader = cmd.ExecuteReader();
              if (reader.HasRows)
              {
                  while (reader.Read())
                  {
                      MaintReviewer reviewer = new MaintReviewer();
                      reviewer.EmailIDReviewer = reader["EmailID_Reviewer"].ToString();
                      reviewer.ReviewerName = reader["Reviewer_Name"].ToString();
                      reviewer.ReviewerEmail = reader["Reviewer_Email"].ToString();
                      reviewer.EmailIDTeamLead = reader["EmailID_TeamLead"].ToString();
                      reviewer.TeamLeadName = reader["TeamLead_Name"].ToString();
                      reviewer.TeamLeadEmail = reader["TeamLead_Email"].ToString();
                      reviewer.Site = reader["Site"].ToString();
                      reviewer.BusinessUnit = reader["Business_Unit"].ToString();
                      reviewer.Group = reader["Group"].ToString();
                      reviewer.Station = reader["Station"].ToString();
                      reviewer.PKGDepartment = reader["Pkg_Department"].ToString();
                      reviewer.Region = reader["Region"].ToString();
                      reviewer.Account = reader["Account"].ToString();
                      reviewer.KeyField = reader["Key_Field"].ToString();
                      reviewer.EmailIDSiteManager = reader["EmailID_SiteManager"].ToString();
                      reviewer.SiteManagerName = reader["SiteManager_Name"].ToString();
                      reviewer.SiteManagerEmail = reader["SiteManager_Email"].ToString();
                      reviewer.EmailIDSiteDirector = reader["EmailID_SiteDirector"].ToString();
                      reviewer.SiteDirectorName = reader["SiteDirector_Name"].ToString();
                      reviewer.SiteDirectorEmail = reader["SiteDirector_Email"].ToString();
                      reviewer.EmailIDPresident = reader["EmailID_President"].ToString();
                      reviewer.PresidentName = reader["President_Name"].ToString();
                      reviewer.PresidentEmail = reader["President_Email"].ToString();
                      reviewer.Customer = reader["Customer"].ToString();
                      reviewer.Flag = reader["Flag"].ToString();
                      reviewer.CreatedBy = reader["CreatedBy"].ToString();
                      reviewer.DateCreated = reader["DateCreated"].ToString();
                      reviewer.LastUpdatedBy = reader["LastUpdatedBy"].ToString();
                      reviewer.DateUpdated = reader["DateUpdated"].ToString();
                      string[] row = { reviewer.EmailIDReviewer, reviewer.ReviewerName, reviewer.ReviewerEmail, reviewer.EmailIDTeamLead, reviewer.TeamLeadName,
                                       reviewer.TeamLeadEmail, reviewer.Site, reviewer.BusinessUnit, reviewer.Group,  reviewer.Station, reviewer.PKGDepartment,
                                       reviewer.Region, reviewer.Account, reviewer.KeyField, reviewer.EmailIDSiteManager, reviewer.SiteManagerName,
                                       reviewer.SiteManagerEmail, reviewer.EmailIDSiteDirector, reviewer.SiteDirectorName, reviewer.SiteDirectorEmail, reviewer.EmailIDPresident,
                                       reviewer.PresidentName, reviewer.PresidentEmail, reviewer.Customer, reviewer.Flag, reviewer.CreatedBy,
                                       reviewer.DateCreated, reviewer.LastUpdatedBy, reviewer.DateUpdated };
                      reviewers.Add(reviewer);
                  }
                  MaintReviewertbl.DataSource = reviewers;
                  MaintReviewertbl.Refresh();
              }
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
          finally
          {
              conn.Close();
              conn.Dispose();
              cmd.Dispose();
          }
      }
  </code></pre>