title: How do I use MAX and Count with two table
body: <p>I have a query that needs to count the field Points. Then returns the highest value. This query does that fine however I now want to link another table 'Team(PlayerID) with Player(PlayerID), So it shows the player team details etc. I attempted to do that normally on how you would join table but keep getting errors. I also do not want to use the order by desc - First row only. (Oracle)</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT PlayerID, COUNT(Points)
  </code></pre>