Postgres Pro
Downloads
Home   >   mailing lists

Re: simple (?) join - Mailing list pgsql-sql

From Gary Stainburn
Subject Re: simple (?) join
Date
Msg-id 200909281443.53367.gary.stainburn@ringways.co.uk
Whole thread Raw
In response to simple (?) join  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Tree view 
On Monday 28 September 2009 13:30:32 you wrote:
> SELECT o.*, ol.*
>   FROM orders o
>        LEFT JOIN (
>          SELECT ol.o_id, MAX(ol_timestamp) AS maxts
>            FROM orders_log ol
>           GROUP BY 1
>          ) max_olt
>              ON max_olt.o_id=o.o_id
>        LEFT JOIN orders_log ol
>               ON ol.o_id=o.o_id
>              AND ol.ol_timestamp=max_olt.maxts
> ;

Cheers Jim,

That worked.

Gary

-- 
Gary Stainburn

Gary's Haircut 700
Please visit http://www.justgiving.com/Gary-Stainburn/ to help me 
raise money for Cancer Research - in return I'll have my head shaved

pgsql-sql by date:

Previous
From: David W Noon
Date:
Subject: Re: simple (?) join
Next
From: Jyoti Seth
Date:
Subject: Disable Constraints in Postgresql 8.4