Kan man seletera en WHERE sats i UNION ALL? SQL Server 2005

SELECT  MatchId, LagIdHemma AS TeamId, Resultathemma AS PointsFor, ResultatBorta AS PointsAgainst
       FROM    Match
               UNION ALL
       SELECT  MatchId, LagIdBorta AS TeamId, ResultatBorta AS PointsAway, Resultathemma AS PointsHome
       FROM    Match AS Match_1) AS view1 INNER JOIN
               Team ON view1.TeamId = Team.TeamId

Du kan ha en WHERE till varje SELECT, men inte en övergripande över hela din UNION.

/johan/