Hi there,
this statement works fine but I'm wondering is there any way to
simplify it?

SELECT score,
(SELECT name from players WHERE playerID=records.playerID LIMIT 1) as
playername,
(SELECT name from teams WHERE teamID=records.teamID LIMIT 1) as
teamname
FROM records

Thanks for any help!
Ciarán