Re: Selecting all from one table and a MAX value from another table

[Peter Brawley]

Is this what you mean?

select s.sessionid, d.maxdatatime
from sessions s
join (
  select sessionid, max(datatime) as maxdatatime
  from sessiondata
  group by sessionid
) d using(sessionid);