How Do I Insert Into Another Table The Selected Fields From First Table? I'm Trying This Code But Syntax Error.

con.Open();
                command = new OleDbCommand("INSERT INTO Attendance [StudNum,SubjCode,schedconcat] SELECT StudNum, SubjCode, schedconcat FROM Enlistment [where schedconcat=? AND P=?]", con);
                command.Parameters.AddWithValue("?", lblsched.Text);
                command.Parameters.AddWithValue("?", false);
                adapter.SelectCommand = command;
                adapter.InsertCommand = command;
                command.ExecuteNonQuery();
                con.Close();