View Single Post
Old 11-21-2003, 01:57 PM  
alex79
Confirmed User
 
Join Date: Jun 2002
Location: france
Posts: 996
Quote:
Originally posted by psili
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.
dosen't work
alex79 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote