sql="select top 20 * from zt_Personal_pmember,zt_resumePersonal where zt_resumePersonal.resume_flag=1 and zt_resumePersonal.resume_quser=1 and zt_resumePersonal.resume_openness=0 order by resume_announcedate desc,resume_id desc"  

出现的问题 ：1.循环输出的内容多于20条。
             2.内容有重复输出。
             3.姓名能正常输出，但对应的其他记录却是重复的。
以下是循环部分：
  ...  
<%
         i=1
        do while not rs.eof
        resume_age=year(date())-year(rs("resume_birth"))
        resume_position=rs("resume_position")
        resume_shiptype=rs("resume_shiptype")
        resume_gt=rs("resume_gt")
        resume_pay=rs("resume_pay")
        
        person_name=rs("pmember_name")
        resume_announcedate=rs("resume_announcedate")
        resume_id=rs("resume_id")
        resume_free=rs("resume_free")
        if i mod 2=0 then
        %>
          <tr bgcolor='#FFFFFF'>
         <%
         else
        response.write "<tr bgcolor='#F5F5F5'>"& vbcrlf
        end if
         %>
            <td width="10%" align="center" HEIGHT="20"><a href="person/cnresume_view.asp?rid=<%=resume_id%>" target="_blank"><%=person_name%></a></td>
            
            <td width="10%" align="center"><%=resume_age%></td>
             <td width="10%" align="center"><%=resume_position%></td>
            <td width="15%" align="center"><%=resume_shiptype%></td>
            <td width="15%" align="center"><%=resume_gt%></td>
            <td width="10%" align="center"><%=resume_pay%></td>
            
            <td width="15%" align="center"><%if resume_free=1 then response.Write "自由船员" else response.Write "非自由船员"%></td>
            <td width="15%" align="center"><%=resume_announcedate%></td>
          </tr>
        <%
        rs.movenext
        i=i+1
        loop
        response.Write"</table>"
        rs.close
      %>
...

请大家帮我分析分析啊 ？

你的SQl语句中的两张表没有关连。
它将会分别在两张表中查找符合要求的数据，所以会出这你所看到的结果。

知道了，谢谢！