[Zope] converting SQL select list into unique values

[Darcy Clark]

I have a non-unique column in a MySQL table - I have looked hard for a
way in SQL to convert the results of a SELECT into a list of unique
values. I know how to define a table at CREATE to have UNIQUE columns
but this is not what I want to do.

For example :

If the result of the SELECT is :
1, 3, 3, 4, 2, 6, 8, 9, 4, 2, 3, 6

I would like to return:
1, 2, 3, 4, 6, 8, 9

i.e. only the unique values of the list.

any pointers ? if SQL can't do this, can Zope ? (I'm sure Zope can do
it, it can do everything :)

Darcy
-- 
---------------------------------------------------
Ph: (734) 764 3377 
Email: darcyc@engin.umich.edu
URL: http://www-personal.engin.umich.edu/~darcyc/
---------------------------------------------------
'If you're not part of the solution, you're part of the precipitate'
..... Steven Wright