Re: Join question

oops...

I meant "DISTINCT ON ( a_id )"

--- Richard Broersma Jr <rabroersma@yahoo.com> wrote:
>     SELECT a.x, b.x
>       FROM ( SELECT DISTINCT ON ( a_id ) a_id, b_id                              ^^

>                FROM c ) AS c( a_id, b_id )
> INNER JOIN a
>         ON c.a_id = a.id
> INNER JOIN b
>         ON c.b_id = b.id;
> 
> Regards,
> Richard Broersma Jr.
> 
> 
> 
>