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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
