Re: Multiple records returned by a JOIN

[Alexander Farber]

Or actually I can not use SELECT UNION here, because then I only get 10
records of the condition uid = player1 and then nothing would be left for
the other condition uid = player2