title: Rails query for joining tables
body: <p>I have 2 tables. Game and game_report</p>
  <p>game table has fields : id, home_team_id, away_team_id, home_club_id, away_club_id etc</p>
  <p>game_report has fields: id, game_id, report_type, team_id etc</p>
  <p>team_id in game_report table is either home_team_id or away_team_id from game table.</p>
  <p>I need a query to check in which if home_team_id and away_team_id from game table has the same report_type or not</p>