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