You could, rather than select the whole date field (which will probably includes the time? hence why the row is shown as not distinct) select the year(date), month(date), day(date) then the only way you'll get 2 candidate ids is if one candidate id has two entries for one given day. Or you could group if by month/year/whatever.
If you don't select the date in some form like this, the database can't know which date it should extract for a given (distinct) candidate id HTH Alex -----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 15 February 2005 14:58 To: CF-Talk Subject: Re: a distinct sql problem.... the only problem is that I need that date object as well. Unless I do 2 queries and then perform some kind of checking and throw the final results into a structure. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
