sql语句查询与字符串匹配的语句问题~~~~~~~~~~菜鸟问题呀~~~求救!
数据表Products 的ProductID包括book1,book2,book3,.....
sql="select * from Products"
sql=sql & " Where ProductID in (" & List1 & ")"
其中List1是一字符串变量,形如"'book1','book2','book3','book4','book5','book6','book7','book8','book9',...."
而又另有List2字符串变量是在List1中部分字符串,任意的,如"'book2','boo4','book6'....."
现在想用sql语句查询List1中除去List2的那些字段数据,能实现吗>?
怎样实现???
==================
我用了sql=sql & " Where ProductID in (" & List1 & ")" not in (" & List2 & ")" 编译说这种语句是错误的~~~~!!!
如何实现呀~~~~谢谢!