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]
