Sql statement with "group by" and "having"

      "SELECT * FROM Customers; SELECT * FROM Orders", connection)

myAdapter.Fill(dsTables)
dsTables.Tables(0).TableName = "Customers")
dsTables.Tables(1).TableName = "Orders")

 chk the below link 
http://vb.net-informations.com/dataset/dataset-multiple-tables-sqlserver.htm

this.WindowState = FormWindowState.Maximized;
            NOVITableAdapter noviTA = new NOVITableAdapter();
            //this.NOVITableAdapter.Fill(this.dataSet1.NOVI);
            noviTA.Fill(dataSet1.NOVI);

            NALOG1TableAdapter nalogTA = new NALOG1TableAdapter();
            nalogTA.Fill(dataSet1.NALOG1);

            MAGACINTableAdapter magTA = new MAGACINTableAdapter();
            magTA.Fill(dataSet1.MAGACIN);
           
            string comstring="SELECT NOVI.GBR, NOVI.AB, NALOG1.DATA, Min(NALOG1.POCKM) AS MinOfPOCKM, Max(NALOG1.KRAJKM) AS MaxOfKRAJKM, (Max(NALOG1.KRAJKM)-Min(NALOG1.POCKM)) AS RAZLIKA FROM (NALOG1 INNER JOIN MAGACIN ON NALOG1.GBRV=MAGACIN.GBR) INNER JOIN NOVI ON NALOG1.GBRV=NOVI.GBR GROUP BY NOVI.GBR, NOVI.AB, NALOG1.DATA HAVING (((NOVI.GBR)>="1081" And (NOVI.GBR)<="1149") AND ((NOVI.AB)="1") AND ((NALOG1.DATA)=#10/31/2011#))";
           
            conn.Open();
            //odbcConnection1.Open();
            OleDbDataAdapter oleDBDataAdapter1 = new OleDbDataAdapter(new OleDbCommand(comstring, conn));
            OleDbCommand command1 = new OleDbCommand();

            command1.Connection = conn;

            command1.CommandText = comstring;
            command1.ExecuteNonQuery();
            conn.Close();