Select Participants from table will result in
Participants ------- John Nancy Jem Albert Smith Daniella
I want a query where the results shows
Player Opponent ------ -------- John Nancy Jem Albert Smith Daniella
A good sample for this question is the query used in generating single-elimination tournament pairings.
Thank you very much in advance