Re: select question...
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.
Subject
Written By
Posted
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.