On Thu, 9 Mar 2006, 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 a
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 o
Tony Smith wrote on
Thursday, March 09, 2006 6:33 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] select where in and order
>
>
> I have two tables action and group:
>
> action
>
> id,
> name
>
> group:
> ---
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 ac
