You previewed the possibility of
having orders without any matching entry on orders_log with your left
join, something that I haven't. Gary, will you have
records on your orders table that
don't reference any record on your orders_log table? If so, Justin's
query is the right one you should use.
You return the full record from
orders and an additional column from orders_log, the ol_timestamp
column. I understood that Gary wanted the full record from orders_log,
not
just the timestamp column. That
part is done by my subquery .
I think Gary could clarify what he
wants exactly. Gary? :)
Yes gary please do if these do not answer your questions???
Also, Justin, your query
design seems right to me, but maybe you should add this (the part in
comment) to your subquery
SELECT MAX(ol_timestamp) /* as ol_timestamp */ , o_id FROM
orders_log group by o_id
because the MAX(ol_timestamp) will receive the name max, not
ol_timestamp, and probably
the parser will complain that column ol_timestamp does not
exist.
Ain't I right?