Postgres Pro
Downloads
Home   >   mailing lists

Re: Join question - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: Join question
Date
Msg-id 663038.58978.qm@web31802.mail.mud.yahoo.com
Whole thread Raw
In response to Join question  (tyrrill_ed@emc.com)
List pgsql-sql
Tree view 
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.
> 
> 
> 
>

pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Join question
Next
From: Richard Broersma Jr
Date:
Subject: SELECT syntax synopsis: column_definition?