select (select count(*) from tb_name where 已阅读 like '%2%') as a,
(select count(*) from tb_name where 未阅读 like '%2%') as b,
(select count(*) from tb_name where 需回复文件 like '%2%') as c;
(select count(*) from tb_name where 未阅读 like '%2%') as b,
(select count(*) from tb_name where 需回复文件 like '%2%') as c;
/wsj/contents/main.asp,行22
set rs=server.createobject("adodb.recordset")
sql="select (select count(*) from documents where send_depart1='"&oabusyname&"') as a,(select count(*) from documents where send_depart1='"&oabusyname&"') as b,(select count(*) from documents where send_depart1='"&oabusyname&"') as c"
rs.open sql,conn,1,1%>
select sum(已阅读 regexp '[2]'),sum(未阅读 regexp '[2]'),sum(需回复文件 regexp '[2]') from table;