Microsoft JET Database Engine (0x80040E14) 求助！

[乡村小盗]

Microsoft JET Database Engine (0x80040E14)
语法错误。 在查询表达式 'name in(select name from stu_info_book department='信息管理系')' 中。
/dgxx/department/xxxc.asp, 第 40 行

代码如下：
set rs=server.createobject("adodb.recordset")
sql="select * from albums_book where name in(select name from stu_info_book department='"&rsx("name")&"')"
rs.open sql,conn,1,3
if rs.bof and rs.eof then
这个多重条件怎么写！！

[街头小贩]

where呢？

sql="select * 
     from albums_book 
     where name in(
          select name 
          from stu_info_book 
          where department='"&rsx("name")&"'
     )"

[hookee]

1 少where
2 name关键字加[]

sql = "select * from albums_book where [name] in (select [name] from stu_info_book where department='" & rsx("name") & "')"

[Dogfish]

hookee正确，是少了个where。