28,409
社区成员




<%
set SY_RS = server.createobject("adodb.recordset")
SY_SQL="SELECT a.收款情况 FROM 业务单 AS a INNER JOIN 记帐日报表 AS b ON a.协议编号=b.协议编号 GROUP BY a.协议编号,a.收款情况,b.ID,b.协议编号"
SY_RS.Open SY_SQL,Conn,1,3
if not (SY_RS.bof and SY_RS.eof) then
do while not SY_rs.eof
Response.Write(SY_rs("a.收款情况"))
SY_rs.movenext
loop
end if
SY_rs.close
set SY_rs=nothing
%>
<%
set SY_RS = server.createobject("adodb.recordset")
SY_SQL="SELECT a.*,b.* FROM 业务单 AS a INNER JOIN 记帐日报表 AS b ON a.ID=b.ID GROUP BY a.ID,a.收款情况,b.ID,b.內容"
SY_RS.Open SY_SQL,Conn,1,3
if not (SY_RS.bof and SY_RS.eof) then
do while not SY_rs.eof
Response.Write(SY_rs("b.收款情况"))
SY_rs.movenext
loop
end if
SY_rs.close
set SY_rs=nothing
%>