ohne join zb
PHP-Code:
SELECT
a.id,a.result ,b.name as n1,c.name as n2
FROM
matches as a ,
players as b,
players as c
where a.n1=b.id and a.n2=c.id
ORDER BY id DESC
mfg
trotzdem zum obengenannten und gleichzeitigen infos zu "join"'s
link:
http://dev.mysql.com/doc/refman/5.1/de/join.html