为特定 ID 提取的重复数据

问：

有一个具有不同 ID 的数据，其中包含子 ID。例如。ID-abcd、子 ID-abcd1、abcd2。但对于特定 ID，子 ID 获取的数据与父 ID 相同。例如：ID-abcd，子ID-abcd。

我认为我的循环中存在一些问题，但想不出任何解决方案。

循环代码：

 Private Sub PrintTabs(tableSuffix As String, idSO As String, vol As String, ByRef myConnection As SqlConnection)

        Dim tabColor As String = ""
        Dim numTab As Integer
        Dim mycVolTab As New SqlCommand("SELECT QI_MATERIAL,QIV_ID,QPSOPROD_VOLID " &
                                          " FROM QUO_OFFER_PROD_VOL " &
                                          " LEFT OUTER JOIN QUO_OFFER_PRODUCT ON QIV_PRODID = QI_ID " &
                                          " LEFT OUTER JOIN QUO_OFFER_PROD_SO_PROD" & tableSuffix & " ON QPSOPROD_VOLID = QIV_ID " &
                                          " WHERE QPSOPROD_SOID = @QIV_ID ORDER BY QI_MATERIAL ", myConnection)
        mycVolTab.Parameters.AddWithValue("@QIV_ID", idSO)
        Dim myrVolTab As SqlDataReader = mycVolTab.ExecuteReader

        Dim i = 0
        While myrVolTab.Read
            If vol = myrVolTab("QIV_ID") Then
                tabColor = ""
                numTab = i
            Else
                tabColor = "background-color:#c0c0c0 !important;cursor:pointer;border-color:#c0c0c0"
            End If
            DIV_TABS.InnerHtml &= "<div class='fleft boxSectionTit2' style='width:auto !important;margin-left:10px;" & tabColor & "' onclick=viewSO(" & idSO & "," & myrVolTab("QPSOPROD_VOLID") & ")>" & myrVolTab(0) & "</div>"
            i += 1
        End While

        myrVolTab.Close()
    End Sub

在图像中，上面的输出是显示两个值的不正确的 id。下面的 id 正确显示单个值。