Hello, you might want to try select DISTINCT ? http://www.mysqlfreaks.com/statements/18.php
/Jonas ----- Original Message ----- From: "Carl Schéle, IT, Posten" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 17, 2004 3:49 PM Subject: SQL-HELP 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]