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

thanks i how ever views this im figure it out myself

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.