用记录集合当作条件来查询，有问题，说是类型不匹配。

[happymingnan]

sql = "select category from category"
Set rs = getRS(sql) '返回一个记录集
sql = "select distinct parentcategory from category where parentcategory not in('" & rs & "') " '然后用记录集当作条件来查询。
Set rs = getRS(sql) '返回最终结果 ，

可这样写有错，说是类型不匹配，
我该怎么做呢？
恳求帮忙！

[say1no2]

把
sql = "select distinct parentcategory from category where parentcategory not in('" & rs & "') "
改成
sql = "select distinct parentcategory from category where parentcategory not in(" & rs & ") "

试试

[angelheavens]

sql = "select distinct parentcategory from category where parentcategory not in (select category from category)"
Set rs = getRS(sql)

[happymingnan]

还是报错，“类型不匹配，实事错误，13 ”

[happymingnan]

龙辉的办法，我先看看，waiting～～～～

[happymingnan]

龙辉，偶像～～～～！！！