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 :-).
Brett Randall
From: "Zavier Sheran" <[EMAIL PROTECTED]> To: "maxdb" <[EMAIL PROTECTED]> Subject: SELECT DISTINCT doesn't work Date: Mon, 31 May 2004 04:10:29 -0600
I have the following query:
SELECT DISTINCT record_id, name, url, email, phone, city, state, zip, latitude, longitude FROM cars WHERE seller = 'd' AND make = '20"
According to the manual, DISTINCT should filter duplicate results, but it doesn't...
Any ideas?
-Zavier
_________________________________________________________________
SEEK: Now with over 50,000 dream jobs! Click here: http://ninemsn.seek.com.au?hotmail
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
