How to tract data from multiple tables?

[dilchahatahai]

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft

Public Class Form1
'Dim rpt As New final() 'The report you created.
Dim rpt As New CrystalReport1() 'the 2nd report

Dim myConnection As New SqlConnection

Dim MyCommand As New SqlCommand()
Dim myDA As New SqlDataAdapter()
Dim myDS As New runDataSet() 'The DataSet you created.


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Try

myConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=G:\run1\run1\ run.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
MyCommand.Connection = myConnection
MyCommand.CommandText = "SELECT * from run"

MyCommand.CommandType = CommandType.Text
myDA.SelectCommand = MyCommand

myDA.Fill(myDS,"run")
rpt.SetDataSource(myDS)
CrystalReportViewer1.ReportSource = rpt

Catch Excep As Exception
MessageBox.Show(Excep.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
End Sub


End Class


this code is working
but it is for single table
i also want to generate reports from multiple table ........wht i need to add ?
try solv this plz!!