ASP输出数据重复问题

[jhtongnet]

<%
Dim rsjingjia
Set rsjingjia = Easp.db.GetRecordBySQL("Select TOP 4 a.detailsid,a.chrtitle,b.liveid, imgt=b.chrimage From [mh163k_live] a Join [live_file] b On a.detailsid = b.liveid where jingjia=1 order by a.detailsid desc")
While Not rsjingjia.eof
%>
            <dd>
              <div class="i"><a href="live/live_<%=rsjingjia("detailsid")%>.html"><img src="/<%=rsjingjia("imgt")%> /></a></div>
              <div class="til"><a href="live/live_<%=rsjingjia("detailsid")%>.html"><%=rsjingjia("chrtitle")%></a></div>
            </dd>
<%
  rsjingjia.movenext()
Wend
Easp.db.C(rsjingjia)
%>

输出 imgt有重复 请问怎么判断只输一条

[Dogfish]

1楼是写错字。
distinct

[jhtongnet]

[Quote=引用 3 楼 dogfish 的回复:]
1楼是写错字。
distinct
[/Quote]

Select distinct TOP 4 a.detailsid,a.chrtitle,b.liveid, imgt=b.chrimage From [mh163k_live] a Join [live_file] b On a.detailsid = b.liveid where jingjia=1 order by a.detailsid desc

还是有重复的。。。

[shenxian5]

用inner join试试？

[三石-gary]

Select distinc TOP 4 a.detailsid,a.chrtitle,b.liveid, imgt=b.chrimage From [mh163k_live] a Join [live_file] b On a.detailsid = b.liveid where jingjia=1 order by a.detailsid desc

[jhtongnet]

[Quote=引用 1 楼 zsx841021 的回复:]
Select distinc TOP 4 a.detailsid,a.chrtitle,b.liveid, imgt=b.chrimage From [mh163k_live] a Join [live_file] b On a.detailsid = b.liveid where jingjia=1 order by a.detailsid desc
[/Quote]

你这么搞不行 MSSQL分析器执行都报错