Hi Noah, How about: SELECT u.user_name FROM users u LEFT JOIN user_log l ON u.user_id = l.user_id WHERE DATEDIFF(dd, MAX(l.login_time), GETDATE()) >= 90 HTH Tim -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Noah St. Amand Sent: 09 January 2007 19:46 To: thelist at lists.evolt.org Subject: [thelist] Last Login Time SQL Hi, I'm trying to come up with an SQL statement that will return all of the users who haven't logged in to a system in 90 days or more. I can get the information I need with a nested query, but given that there are a lot of records, it's pretty slow and inefficient. There must be a good way to do it, but I'm not fluent enough in SQL to figure it out. The details: I have two tables, one of which, "users", stores typical user data (user_id, user_name, password, email) and the other, "user_log" just records logins (user_id, login_time). I need to get a list of all the user_names of people whose most recent login_time is 90 days or more before right now. This is classic ASP querying Access, but if anyone has any ideas in reasonably generic SQL, I can translate as necessary. Thanks, Noah -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !