Well, the problem was that I inluded the record_id column, which is a unique identifier... It works fine now.
Thanks to Sven and Brett for the quick help Best wishes -Zavier ----- Original Message ----- From: "Sven K�hler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 31, 2004 5:01 AM Subject: Re: SELECT DISTINCT doesn't work > > You might want to check that you don't have any tuples that are > > otherwise identical apart from NULLs versus empty strings in a character > > field - DISTINCT treats these rows as, well, distinct :-). > > i think he shouldn't include the record_id, since it might be a > serial-column and therefor differs for each record. > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
