|
fchachar
Starting Member
15 Posts |
 Posted - 11/08/2012 : 16:30:09
|
This sound stupid but I was wondering if anyone of you could help me achieve this goal.
I have a list of users I would say about 4500 so I am using this Query.
SELECT Username, MAX(TimeEntered) as [Last Accessed System]
FROM AuditEvent
LEFT JOIN AuditType ON AuditEvent.TypeID = AuditType.TypeID
Where Username IN
-- There are about 4500 Users here.
('User1', 'User2', 'User3', 'Usern')
GROUP BY Username
ORDER BY [Last Accessed System]
The results return with 3120 transactions, my question is how do I find out about those who missed out of 4500. 1380 did not make any transaction or create any entry in the Table, I am interested to know the usernames of 1380 users. How do I get that?
Thanks. |
Edited by - fchachar on 11/08/2012 16:30:41
|
|
Query question
