2,099
社区成员
发帖
与我相关
我的任务
分享
select count(*) from taborder_product where pro_id in (select id from tabproduct where ManageName_id= 5
<tr class="TR" height="18">
<td align="left"> 产品个数</td>
<td width="70%">
<%
dim sum
sum=conn.execute("select count(*) from tabproduct where ManageName_id= " & Session("ManageName_id") & "")
response.Write(sum(0))
%>
个产品量(通常加100个产品,会每月出一单)
</td>
</tr>
<tr class="TR" height="18">
<td align="left"> 订单个数</td>
<td>
<%
dim order_sum_sql
'ss="select count(pro_id) from taborder_product where pro_id in (select id from tabproduct where ManageName_id= " & Session("ManageName_id")
'order_sum_sql=conn.execute(ss)
order_sum_sql=conn.execute("select count(pro_id) from taborder_product where pro_id in (select id from tabproduct where ManageName_id= " & Session("ManageName_id") & "")
'response.Write ss
response.Write order_sum_sql(0)
%>
个
</td>
</tr>
SELECT COUNT(DISTINCT pro_id)
FROM taborder_product
WHERE pro_id IN ( SELECT id
FROM tabproduct
WHERE ManageName_id = 5 )
SELECT COUNT(DISTINCT pro_id)
FROM taborder_product
WHERE pro_id IN ( SELECT id
FROM tabproduct
WHERE ManageName_id = 5 )