title: Retrieve data using DataReader from multiple tables in mySQL
body: <p>How would I retrieve the data from the 'DAILY_CALCULATIONS' table</p>
  
  <pre><code>  Dim SqlQuery As String = "SELECT WEEKLY_TIMECARD.*,DAILY_CALCULATIONS.*,EMPLOYEE_PROFILES.EMPLOYEE_NUMBER "
      SqlQuery = SqlQuery + " FROM WEEKLY_TIMECARD, DAILY_CALCULATIONS, employee_profiles WHERE employee_profiles.employee_number"
      SqlQuery = SqlQuery + " = WEEKLY_TIMECARD.employee_number AND EMPLOYEE_PROFILES.EMPLOYEE_NUMBER = DAILY_CALCULATIONS.EMPLOYEE_NUMBER AND"
      SqlQuery = SqlQuery + " WEEKLY_TIMECARD.WEEK_NUMBER = DAILY_CALCULATIONS.WEEK_NUMBER AND WEEKLY_TIMECARD.EMPLOYEE_NUMBER ="
      SqlQuery = SqlQuery + "'" + txtENumber.Text + "' AND WEEKLY_TIMECARD.WEEK_NUMBER = '" + CBWeekNum.SelectedItem + "'"
  
      Try
  
          con.Open()
  
          If con.State = ConnectionState.Open Then
              con.ChangeDatabase("shopclocksoftware")
              Command = New MySqlCommand(SqlQuery, con)
              Data = Command.ExecuteReader()
  
              While Data.Read
                  txtHUnits.Text = Data(2).ToString
                  txtOUnits.Text = Data(3).ToString
              End While
  </code></pre>
  
  <p>I had a look at the Data.NextResult method, but I wasn't able to implement it properly, Any ideas? </p>