MySQL Forums
Forum List  »  Newbie

Re: select question...
Posted by: Felix Geerinckx
Date: July 18, 2005 02:48AM

Chris Flora wrote:

> Ok, so how do I get a list of all the users that are NOT currently logged in?

SELECT
users.user_name
FROM users
LEFT JOIN logged_users ON logged_users.user_id = users.user_id
WHERE
logged_users.user_id IS NULL;

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
July 14, 2005 10:21PM
Re: select question...
July 18, 2005 02:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.