Re: query data from 2 tables with MAX(datetime)

[Peter Brawley]

Is this what you mean?

select a.lastname, a.firstname, max(b.datetime) as 'Last login'
from members a
join logins b using(username)
group by a.lastname, a.firstname;