SQL VisualBasic 2010使用表2查看表1的结果，其中id listview.item(0).text

Question

您好，我需要帮助listview1显示表Youtube的内容，但如果表viewed的值相同​​,在其CCD_ 4为CCD_。怎么办？

Table1(youtube)
    id  user    userlogin   url     
    1   22      12345       http/...1
    2   23      tommy       http/...2
Table2(viewed)
    user_id     site_id
    22          1     
    23          2
listview1
    id user url         userlogin 
    1  22   http:/...1 12345
listview2
    id
    22(user id)
ds = New DataSet
    da = New MySqlDataAdapter("SELECT * from youtube where id not in (Select site_id from viewed) and user not in (Select user_id from viewed) where user=ListView1.Items(0).SubItems(0).Text", sqlcon) 
da.Fill(ds, "youtube")
lvDisplay.Items.Clear()
If ds.Tables("youtube").Rows.Count > 0 Then
    For i As Integer = 0 To ds.Tables("youtube").Rows.Count - 1
        With lvDisplay.Items.Add(ds.Tables("youtube").Rows(i).Item(0).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(3).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(4).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(5).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(6).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(7).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(13).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(2).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(1).ToString)
            .SubItems.Add(ds.Tables("youtube").Rows(i).Item(14).ToString)

请更正

http://obrazki.elektroda.pl/1681222700_1409155841.png

Answer 1

已解析

"SELECT *FROM(youtube) WHERE id NOT IN(SELECT site_id FROM youtube INNER JOIN viewed ON youtube.id=viewed.site_id AND viewed.user_id WHERE user_id=" & ListView2.Items(0).SubItems(0).Text & ")"