SELECT personSchool,personAwards,personCompany,personKeywords,personWebsite,substring(personIntro,0,10) as personIntro,(select top 1 photoID from personPhoto b where b.personID = a.personID and available = 1 and photoType = 1) as personphoto,(select top 1 photoID from personPhoto b where b.personID = a.personID and available = 1 and photoType = 2) as funnyphoto,(select top 1 photoID from personPhoto b where b.personID = a.personID and available = 1 and photoType = 3) as wallpaper,(select top 1 photoURL From personPhoto b where b.personID = a.personID and available = 1 and (photostatus = 1 or photostatus = 5 or photostatus = 6)) as keyphotourl,personID,personChineseName as personCName,'' as personEName,personOldName,personByname,personTranslateName,(SELECT TOP 1 id FROM movieact b WHERE b.movieactor = a.personID) as movieact From person a WHERE a.personID = 950925查询数据的时候发现错误,请检查您的查询代码是否正确。