select top 10 * from T_PRODUCT inner join T_USER on T_PRODUCT.C_USER=T_USER.C_USER where T_USER.site='shundeexpo.com' order by newid()
...全文
271打赏收藏
(转帖100分)怎么我的Sql会变成选择全部记录的?
请到这个页面回答问题,谢谢 http://expert.csdn.net/Expert/topic/2369/2369197.xml?temp=6.554812E-02 select top 10 * from T_PRODUCT inner join T_USER on T_PRODUCT.C_USER=T_USER.C_USER where T_USER.site='shundeexpo.com' order by newid()
试试这句:
select top 10 * from (select * from T_PRODUCT inner join T_USER on T_PRODUCT.C_USER=T_USER.C_USER
where T_USER.site='shundeexpo.com') A order by newid()