SQL DISTINCT stuff

hey folks!

i have the followiong table example:

ID----Book-------Category
======================

1          e                 b
2          d                  b
3          w                 a
4          t                  a
5          e                  c

what i'd like to do is get the Distinct categories, but sort them as they are in the DB, ie: according to the ID, to get this:

b
a
c

 but when i write :

"SELECT DISTINCT category FROM tbl ORDER BY ID ASC", i get an error, saying that the "order" clashes with the "Distinct" .

anyone got ideas how to do this>?

thanks!
Snooper

thanks for the reply.

i get this error:

You tried to execute a query that does not include the specified expression 'category' as part of an aggregate function.

ok, tried this, and at least i get no errors... but what i get now, is *all* the categories, sorted ASC - so the DISTINCT or ID havent done anything.

(i got this:
a
a
b
b
c )

lets keep at this... we'll (you'll!) get it in the end :)

Thanks for the reply, michael. i kinda see what you're saying..

option 2 gives:

a
b
c
(which is close, but no cigar)

option 1 gives the same error as before: You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function.

anyways, will keep at it....
THanks
sn