left jointure

[juan bolovar]

Hello world !

I trie this query :

SELECT
T3.Name,
T3.Score,
T4.Score
FROM Mytable T3 LEFT JOIN Mytable T4 ON T3.Name=T4.Name
WHERE T3.Round=3 AND T4.Round=4

I expect a result like :
Name3, Score3, Score4 (-> for lines with Name in T3 and T4)
Name3, Score3, NULL (-> for lines with Name only in T3)

But I dont get any line with NULL in T4.Score, as when I make an INNER JOIN.

Why this query sends me the same result than an INNER JOIN ? Is it impossible to LEFT JOIN the same table ?

I work with MySQL 4.0.22, via phpMyAdmin 2.6.0-pl3.