select top 90 a.movieID,movieScreenedDate as moviedate,movieChineseName as movieCName,(select top 1 photoURL from [moviePhoto] where movieID = a.movieID and photoStatus=1 and available=1) photoURL from movie a,movieCounter b where movieScreenedDate = '1923' and a.movieID = b.movieID and a.available=1 order by b.counterSum desc查询数据的时候发现错误，请检查您的查询代码是否正确。