请教统计显示的问题

[zhx730621]

通过查询统计，有两个结果如下：
month jihuawaiwanchengshu
1 2
2 4
3 15
4 13
5 16
6 12
month hechajihuawanchengshu
3 4
4 3
5 15


但是我需要显示成：

month jihuawaiwanchengshu hechajihuawanchengshu
1 2 0
2 4 0
3 15 4
4 13 3
5 16 15
6 12 0

do while not rs_jihuawai_zijian.eof
%>
<tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
<td align="center" height="25"><%=rs_jihuawai_zijian("month")%></td>
<td align="center"><%=rs_jihuawai_zijian("jihuawanchengshu")%></td>
<td align="center"><%=rs_hechajihuawai("hechajihuawanchengshu")%></td>
<% if rs_hechawjihuawaiancheng("month")="" or isnull(rs_hechawjihuawaiancheng("month")) then %>
<td align="center"><%=0%></td>
<% else %>
<td align="center"><%=rs_hechawjihuawaiancheng("hechajihuawanchengshu")%></td>
<% end if %>
</tr>
<%
rs_jihuawai_zijian.movenext
if rs_hechawjihuawaiancheng("month")="" or isnull(rs_hechawjihuawaiancheng("month")) then
else
rs_hechawjihuawaiancheng.movenext
end if
loop
%>
以上语句无法实现，如何修改，请教各位

[spirit888]

do while not rs_jihuawai_zijian.eof
hechajihuawanchengshu=0
%>
  <tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
<td align="center" height="25"><%=rs_jihuawai_zijian("month")%></td>
<td align="center"><%=rs_jihuawai_zijian("jihuawanchengshu")%></td>
    <% if not rs_hechawjihuawaiancheng.eof then
if rs_hechawjihuawaiancheng("month")=rs_jihuawai_zijian("month") then 
hechajihuawanchengshu = rs_hechawjihuawaiancheng("hechajihuawanchengshu")
rs_hechawjihuawaiancheng.movenext
end if 
end if %>
<td align="center"><%=hechajihuawanchengshu%></td>
  </tr>  
  <%   
       rs_jihuawai_zijian.movenext
 	loop