select where in and order

I have two tables action and group:

action
------------------------
id,
name

group:
------------------------
action_id
rank

I what to select from action table by order by the
rank in the group table.

If I use

select * from action where id in (select action_id
from group order by rank)

The action may not be ordered by rank. How can I do
it?

Thanks,

qq



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com