Chart from different tables

See more:

VB

SQL

How to plot a certain field to chart from different tables in one database
This is for from 1 table how to make it from several tables?

Dim tblFields As String = "select par,day_date from table1 where day_date between 2014-01-01 and 2014-01-31 order by day_date"
     Dim conn As New OleDbConnection(MDBConnString)
     Dim oCmd As New OleDbCommand(tblFields, conn)
     Dim oData As New OleDbDataAdapter(tblFields, conn)
     Dim ds As New DataSet
     conn.Open()
 oData.Fill(ds, "table1")
     conn.Close()
 Chart1.DataSource = ds. "table1")
     Dim Series1 As Series = Chart1.Series("Series1")
     Chart1.Series(Series1.Name).XValueMember = "day_date"
     Chart1.Series(Series1.Name).YValueMembers = "par"