I keep hacking at this but haven't been able to get it right yet.
I have two tables
Userinfo contains a login, User's Name, Group Name
Log contains login, host, datetime of last login
What I need to do is return user information (userinfo.name/groupname) of
users that have logged into a particular host last. i.e. A user can log into
any of the hosts but I want to know which one they were on last. Each time
they log the username, host and datetime of login are recorded in the log
table. I've been able to return the last login to the host but I'm at a loss
to get the list of all users that used the host last or all users that have
ever logged into that host.