Query 1

```
$query = "SELECT  match_id, match_date, home_team, 
    home_score, away_score, away_team, rating

              FROM premier_league2 
              WHERE (home_team ='" .$home_team ."'
              OR    away_team ='" .$home_team ."')  
              AND   postponed !=1
              AND   league =1
              AND   match_date <'" . $current_date ."'
              AND   match_date >'" . $newseason ."'
              ORDER BY match_date DESC LIMIT 1";

```

Result

```
676 2013-05-19  Newcastle Utd   0   1   Arsenal -14

```

Query 2

```
SELECT home_per, draw_per, away_per FROM rating WHERE rating = -14;

```

Result

```
28.30 26.50 45.10 

```

Now I am trying to join these query like

```
676 2013-05-19  Newcastle Utd   0   1   Arsenal -14  28.30 26.50 45.10 

```

Rating (-14) is common in both tables, looking for your great help.