Ok simplified scenario:

1 table:

2 Fields:

id ( serial )
genre ( varchar(20) )


I want to SELECT genre only from the table, but need it to be DISTINCT (on genre, obviously). I also need to order it by id ASC. I've found i can't do this even if i include the id in the SELECT since it wants the id to be distinct.

Does anyone have any ideas?

Thanks

Flawless