Order by på Union

Heysan,

Nu har jeg haft problemer med Union og Order by mange gange, men har aldrig helt fundet ud af, hvorfor noget har virket og andet ikke har.

Denne query virker ikke, men fjernes Order by delen virker den fint. Hvad skal rettes for at den virker.

(
    SELECT
        [Time_spent].[hours] AS [Time_spent_hours],
        [Time_spent].[date] AS [date],
        [singlesystem].[name] AS [name],
        [singlesystem].[hours] AS [system_hours]
    FROM
    (
        (
            [Time_spent] INNER JOIN [testing] ON
            (
                [testing].[id] = [Time_spent].[referid]
            )
        )
        INNER JOIN [singlesystem] ON
        (
            [testing].[test platform] = [singlesystem].[name]
        )
    )
    UNION
    (
        SELECT
            [Time_spent].[hours] AS [Time_spent_hours],
            [Time_spent].[date] AS [date],
            [singlesystem].[name] AS [name],
            [singlesystem].[hours] AS [system_hours]
        FROM
        (
            (
                (
                    [Time_spent] INNER JOIN [testing] ON
                    (
                        [testing].[id] = [Time_spent].[referid]
                    )
                )
                INNER JOIN [multisystem] ON
                (
                    [testing].[test platform] = [multisystem].[name]
                )
            )
            INNER JOIN [singlesystem] ON
            (
                [singlesystem].[name] IN
                (
                    [multisystem].[Member_1],
                    [multisystem].[Member_2],
                    [multisystem].[Member_3],
                    [multisystem].[Member_4]
                )
            )
        )
    )
)
ORDER BY [name]

/1