MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Ben Wiechman Date:February 10 2009 5:31pm
Subject:Query Help
View as plain text  
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.  

 

 



Thread
Query HelpBen Wiechman10 Feb
  • RE: Query HelpBen Wiechman10 Feb
RE: Query HelpBen Wiechman10 Feb
  • RE: Query Helpddevaudreuil10 Feb
    • RE: Query HelpBen Wiechman10 Feb