一个有关SQL语句查询出现的怪问题？？？？

[yangguobing]

我在程序在的代码如下：
<!--#include file=cn.asp-->
set rs=server.createobject("adodb.recordset")
sqlstr="select task_no,tb_st_jkpc.pc_name as 计算机名称,tb_st_jkpc.pc_ip as IP地址 from tb_st_jkpc &
where task_no (select task_no from tb_st_task)"
rs.open sqlstr,con,1,3
浏览器出现如下错误提示：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
/web/pc.asp, 第 14 行
但我把sql语句中的条件去掉就好了，请教高手这是为什么

[arclala]

sqlstr="select task_no,tb_st_jkpc.pc_name as 计算机名称,tb_st_jkpc.pc_ip as IP地址 from tb_st_jkpc &
where task_no in (select task_no from tb_st_task)"

[yonghengdizhen]

集合运算一定要用IN操作

[slightgao]

sqlstr = "select task_no,tb_st_jkpc.pc_name as 计算机名称,tb_st_jkpc.pc_ip as IP地址 from tb_st_jkpc " &
"where task_no in (select task_no from tb_st_task)"