It works fine (with a little tweak).
SELECT DISTINCT CASE WHEN c1.winner_1 = c1.winner_2 THEN c1.winner_1 ELSE c1.winner_2
END AS winner FROM champions c1,champions c2 ORDER BY winner ASC
is what I wanted. Thank you very much! Btw, I can't help my webhotel is rotten and
only uses old versions.
Now UNION is implemented in MySQL 4.0.0. and as I stated earlier I run 3.23.58.
-Ursprungligt meddelande-
Från: Rodolphe Toots [mailto:[EMAIL PROTECTED]
Skickat: den 17 februari 2004 16:19
Till: Jonas Lindén; Carl Schéle; [EMAIL PROTECTED]
Ämne: SV: SQL-HELP
yeah
but that wont really do
yeah
but that wont really do it since the names are in two columns
so, there must also be a UNION included
do a union and then select distinct on the result from the union
that should do it (eller hur?)
-Ursprungligt meddelande-
Från: Jonas Lindén [mailto:[EMAIL PROTECTED]
Skickat: den 17
