Hello!

I got a table, champions, looking like this:

 

id                   winner_1         winner_2

--------------------------------------------------------

0                    carl                 mattias

1                    daniel             carl

2                    erik                 daniel

3                    erik                 johan

 

What I want is to retrieve the unique names ie:

 

carl

mattias

daniel

erik

johan

 

I use MySQL 3.23.58 (which means I can't use sub-selects).

 

/Carl

 

Reply via email to