How can i SELECT row with max value : `
select  NATIONALPLAYERS.FIRSTNAME||' '|| NATIONALPLAYERS.LASTNAME as PlayerName,NATIONALPLAYERS.EXPERIENCEID, experience
from NATIONALPLAYERS 
INNER JOIN (select experienceid, MAX( experiences.nationalgames + experiences.internationalgames ) as experience
from experiences 
group by experiences.EXPERIENCEID)plexperience
 on plexperience.experienceid = NATIONALPLAYERS.experienceid;`

> It displays all the records from "PlayerName", "ExperienceID" and "Experience" even though i asked only for the maximum value of experience.