查人人中国名人网told用法:倾尽所有 求一段 asp+access 程序代码
来源：百度文库 编辑：查人人中国名人网 时间：2024/05/11 05:40:15
<%
set rs=server.createobject("adodb.recordset")
sql= "SELECT a.姓名 AS name, a.cpsjz AS jingzhong, b.kemm AS kemeimi "
sql= sql & "FROM (SELECT 姓名, SUM(成品布净重) AS cpsjz "
sql= sql & " FROM yzgybb"
sql= sql & " GROUP BY 姓名) a INNER JOIN"
sql= sql & " (SELECT 织布人, (SUM(领用卷布) * 1000 / SUM(正品袋) - 5) / 0.8 AS kemm"
sql= sql & " FROM ysrbb"
sql= sql & " GROUP BY 织布人) b ON a.姓名 = b.织布人 "
set rs=conn.execute(sql)
do while not rs.eof
%>
所需字段不全 谁能帮我补全他 表在我电脑你 你加我 我发给你 QQ49993324 很急啊 昨天有位前辈帮我写的 我看不懂 所以加不来啊
谢谢大家了 谁能帮我补全 我将倾尽所有 决不失言
set rs=server.createobject("adodb.recordset")
sql= "SELECT a.姓名 AS name, a.cpsjz AS jingzhong, b.kemm AS kemeimi "
sql= sql & "FROM (SELECT 姓名, SUM(成品布净重) AS cpsjz "
sql= sql & " FROM yzgybb"
sql= sql & " GROUP BY 姓名) a INNER JOIN"
sql= sql & " (SELECT 织布人, (SUM(领用卷布) * 1000 / SUM(正品袋) - 5) / 0.8 AS kemm"
sql= sql & " FROM ysrbb"
sql= sql & " GROUP BY 织布人) b ON a.姓名 = b.织布人 "
set rs=conn.execute(sql)
do while not rs.eof
%>
所需字段不全 谁能帮我补全他 表在我电脑你 你加我 我发给你 QQ49993324 很急啊 昨天有位前辈帮我写的 我看不懂 所以加不来啊
谢谢大家了 谁能帮我补全 我将倾尽所有 决不失言
把表发过来，我试试
522343207