select count(a.movieID) from movie a,movieCounter b where movieScreenedDate = 2008 and a.movieID = b.movieID and a.available=1查询数据的时候发现错误,请检查您的查询代码是否正确。