SQL Server错误:多部分标识符“C”。名称“不能被绑定”。

I have this SQL query:

我有这个SQL查询:

CREATE VIEW QueryV5 
AS
    SELECT DISTINCT 
        C.Name, P.Name, SUM(Duration.Time) AS TotalTime
    FROM 
        cmpt354_starwars.dbo.Characters C, 
        cmpt354_starwars.dbo.Planets P, 
        (SELECT (T.[Time of Departure] - T.[Time of Arrival]) AS Time 
         FROM cmpt354_starwars.dbo.TimeTable T 
         WHERE T.CharacterName = C.Name AND T.PlanetName = P.Name) AS Duration
    WHERE 
        P.Affiliation = 'neutral'
CREATE VI