View Single Post
Old 11-21-2003, 01:40 PM  
psili
Confirmed User
 
Join Date: Apr 2003
Location: Loveland, CO
Posts: 5,526
So

SELECT DISTINCT(name), date, location FROM tableName

doesn't work.

How about fuckin' around with Group BY clauses (mind i didn't check my syntax cuz i'm lazy)

SELECT name, date, location FROM tableName GROUP BY name, date, location

and see what your result set looks like.
__________________
Your post count means nothing.
psili is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote