query for selecting columns from differents tables

string constr = "Data Source=.\\SQLEXPRESS; database=Library; Persist Security Info=False; Integrated Security=true;";
      using (SqlConnection con = new SqlConnection(constr))
      {
          cmd1 = con.CreateCommand();
          cmd1 = new SqlCommand("Select B.BookName, P.Publication from Books B Inner Join Publication P on B.PublicationCode = P.PublicationCode");
                cmd1.Connection = con;

                ds = new DataSet();
                adp = new SqlDataAdapter(cmd1);
                adp.Fill(ds, "Books");

                dataGridView1.DataSource = ds.Tables["Books"].DefaultView;
            }