How do I use MAX and Count with two table
<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>