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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
