SQL subquery

select events.event_id, events.start_date_time_local, map_event_result_home.hi_level_key AS homemap_event_result_away.hi_level_key AS awayFROM events,map_event_result,map_event_result_home,map_event_result_awaywhere events.start_date_time > '20071001' and events.start_date_time < '20080404' and events.event_id=map_event_result.event_id and map_event_result.hi_level='team' and map_event_result.hi_level_key LIKE 'l.nhl.com%' AND map_event_result_home.event_id = events.event_idAND map_event_result_home.alignment = "home"AND map_event_result.away.event_id = events.event_idAND map_event_result_away.alignment = "away"order by events.start_date_time asc