how to select from multiple table?

[shizzle08]

can you help me how to select from multiple tables. so far this is my code how do i

Dim dr As OleDbDataReader

    Dim dc As New OleDbCommand

        dc.Connection = conn
        dc.CommandText = "SELECT * FROM tblClient, tblLoan WHERE ClientNo =  '" & ClientNo & "'"
        dr = dc.ExecuteReader
        If dr.HasRows Then
            While dr.Read

                    'for tblCLient
                    frmClientsProfile.lblClientNo.Text = dr.Item(0)
                    frmClientsProfile.lblFirstName.Text = dr.Item(1)
                    frmClientsProfile.lblLastName.Text = dr.Item(2)
                    frmClientsProfile.lblAge.Text = dr.Item(3)
                    frmClientsProfile.lblAddress.Text = dr.Item(4)
                    frmClientsProfile.lblBirthday.Text = dr.Item(5)
                    frmClientsProfile.lblGender.Text = dr.Item(6)
                    frmClientsProfile.lblContactNo.Text = dr.Item(7)
                    ' for tblLoan
                    'frmClientsProfile.lblBalance.text = dr.item() <- what should i put here?

                End While
            End If

[shizzle08]

thanks i how ever views this im figure it out myself

[poojavb]

Do post your code after u solve it successfully so that it is helpful to others....