UNION/select query, returns an error

 
Name                                      Null?    Type
 ----------------------------------------- -------- -------------
 OPPONENT                                           VARCHAR2(25)
 MATCH_DATE                                         DATE
 MATCH_TIME                                         VARCHAR2(10)
 LOCATION                                           VARCHAR2(20)
 LEAGUE                                             VARCHAR2(30)

select *from ( 
select 'Charlton vs '||Opponent as Team, match_date, Match_time, Location, League from charlton_games@charlton1 UNION 
select 'Liverpool vs '||Opponent as Team, match_date, Match_time, Location, League from liverpool_games@liverpool1 UNION 
select 'Portsmouth vs '||Opponent as Team, match_date, Match_time, Location, League from portsmouth_games@portsmouth1 UNION 
select 'Man U vs '||Opponent as Team, match_date, Match_time, Location, League from man_u_games@man_u1) 
where opponent = 'Everton' and Match_Date>Sysdate
Order by Match_Date;

SELECT team, match_date
FROM (      
      SELECT 'Charlton vs ' ||opponent AS team,
             match_date, 
             location
      FROM charlton_games@charlton1
      UNION
      SELECT 'Liverpool vs ' ||opponent AS team,
             match_date, 
             location
      FROM liverpool_games@liverpool1
      UNION
      SELECT 'Portsmouth vs ' ||opponent AS team,
             match_date, 
             location
      FROM portsmouth_games@portsmouth1
      UNION
      SELECT 'Crystal Palace vs ' ||opponent AS team,
             match_date, 
             location
      FROM palace_games@palace1
      UNION
      SELECT 'MAN U vs ' ||opponent AS team,
             match_date, 
             location
      FROM man_u_games@man_u1
      )
WHERE location = 'Home';