<%
           dim nt
           nt = request.QueryString("nt_upid")
           sql = "select * from Eas_News_Type where nt_upid ="&nt&""
           set rs = ado_query(sql,conn)
           while not rs.eof
          %>
      
          <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="6%"><div align="center"><img src="Images/PRODUCTS-7-Customized _r5_c4_r5_c4.png" width="17" height="14" /></div></td>
            <td width="94%"><span style="font-size: 12px"><a href="product.asp?ns_ntid=<%=rs("nt_id")%>"><%=rs("nt_title")%></a></span></td>
          </tr>
        </table>
         <%
               rs.movenext
                wend
              %>

ns_ntid是另外一个表里面的字段 我该怎么写这个语句呢？

<%
           dim nt
           nt = request.QueryString("nt_upid")
           sql = "select * from Eas_News_Type where nt_upid ="&nt&""
           set rs = ado_query(sql,conn)
           while not rs.eof
          %>
          <%
          sql = "select * from Eas_News_List "
           set rs = ado_query(sql,conn)
          %>
          <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="6%"><div align="center"><img src="Images/PRODUCTS-7-Customized _r5_c4_r5_c4.png" width="17" height="14" /></div></td>
            <td width="94%"><span style="font-size: 12px"><a href="product.asp?ns_ntid=<%=rs("nt_id")%>"><%=rs("nt_title")%></a></span></td>
          </tr>
        </table>
         <%
               rs.movenext
                wend
              %>
会报错 提示未找到项目

<%
           dim nt
           nt = request.QueryString("nt_upid")
           sql = select * from ("select * from Eas_News_Type where nt_upid ="&nt&" union all select * from Eas_News_List where ns_ntid > 80")
           set rs = ado_query(sql,conn)
           while not rs.eof
         %>
这样写报错

我的连接里面要用到ns_ntid，而ns_ntid不在Eas_News_Type 这个表里面，
也就是ns_ntid缺少定义， 我该怎么定义ns_ntid 为另外一个表里面的字段。