一对多的重复。请教高手写这样Sql语句＊＊＊是不是很难＊＊＊

Question

我是这样写的：
SELECT distinct dbo.PlayActors.Name AS Person,        //  此处是人名  麻烦也是在这里
  dbo.Movies.MovieID, dbo.Movies.Name, dbo.Languages.Name AS [Language], 
      dbo.MovieTypes.Name AS Type, 
      dbo.Movies.ClickNO, dbo.Movies.PG, dbo.Movies.InDate, 
      dbo.Movies.StarNO
FROM dbo.Movies INNER JOIN
      dbo.Languages ON 
      dbo.Movies.LanguageID = dbo.Languages.LanguageID INNER JOIN
      dbo.MovieTypes ON 
      dbo.Movies.TypeID = dbo.MovieTypes.TypeID LEFT OUTER JOIN
      dbo.PlayActors INNER JOIN
      dbo.MoviePlayActor ON dbo.PlayActors.ActId = dbo.MoviePlayActor.ActID ON 
      dbo.Movies.MovieID = dbo.MoviePlayActor.MovieID
order by dbo.Movies.MovieID

Answer 1

http://www.csdn.net/expert/topic/815/815139.xml?temp=.293606

Answer 2

结贴：
wzsswz(岌岌荆棘)得分