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