Select Top 15 a.ID,a.Topic,a.userid,a.province,a.city,a.price,a.ProducingPlace,a.IssueDate,a.instructionmore,a.productpic,a.pm,a.isvip,b.companyname,b.userflag,b.vip,b.regdate From tbl_ProductSupply a with(nolock) left join tbl_UserID_EnterpriseB b with(nolock) on a.userid=b.userid Where a.IndustryID=5071 and ( a.province=3 or a.Province=0) And a.KindOfInfo=1 And a.issuestate=1 Order By a.pm DESC,a.Province DESC