พี่รบกวนแล้ว พี่ช่วยดูโค้ด sql นี้หน่อยน่ะค่ะ พอดีน้องต้องการเขียน sql เพื่อต้องการ show ข้อมูล บน label ค่ะ

 Protected Sub bindShow()
        Dim sql As String
        Dim dv As DataView
ส่วน sql ตรงนี้อ่ะค่ะ 
     [color=orange]   sql = "SELECT tb_ibank_complaint.*,tb_complaint_occu.Detail "
        sql += "FROM tb_ibank_complaint INNER JOIN tb_complaint_occu"
        sql += "ON tb_ibank_complaint.Occu = tb_complaint_occu.Id "        'sql = "Select TypeR,Subject,SubmitDate,Message,Name,Lastname,IdCard, Occu, ContactPhone, Email, Address FROM tb_ibank_complaint where Id = '" & Request.QueryString("CId") & "' "

        Response.Write(sql)
        dv = ObjDb.GetDataSet(sql).Tables(0).DefaultView
        If dv.Count > 0 Then
            Me.lbTypeR.Text = dv.Item(0)("TypeR").ToString
            Me.lbSubject.Text = dv.Item(0)("Subject").ToString
            Me.lbSubmitDate.Text = dv.Item(0)("SubmitDate").ToString
            Me.lbMessage.Text = dv.Item(0)("Message").ToString
            Me.lbName.Text = dv.Item(0)("Name").ToString
            Me.lbLastname.Text = dv.Item(0)("Lastname").ToString
            Me.lbIdCard.Text = dv.Item(0)("IdCard").ToString
            Me.lbOccu.Text = dv.Item(0)("Detail").ToString
            Me.lbContactPhone.Text = dv.Item(0)("ContactPhone").ToString
            Me.lbEmail.Text = dv.Item(0)("Email").ToString
            Me.lbAddress.Text = dv.Item(0)("Address").ToString
        End If

    End Sub