Tony Smith wrote:
> 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)
Why not
select * from action a, group g where a.id=g.action_id order by rank desc;
?
--
Postgresql & php tutorials
http://www.designmagick.com/