Need Help with Query

[Santal_Maluko]

Hi,

I would like to have some help here

I have 2 tables:
events(eventid, description, userid) -> description can be Checkin or Checkout;

users(userid, username)



I would like to have all the users that their LAST event is CHECKIN

Seems easy but I can't get a query to do this....

Thanks in Advance

[Zeb]

you didn't say what DB you are using, but the following should be pretty close to what you want:

SELECT users.*
FROM events e1, (SELECT MAX(eventID) event FROM events GROUP BY UserId) e2, users
WHERE e1.eventId = e2.event
AND e1.description = "CHECKIN"
AND e1.userId = users.userId

it could probably be more efficient...

[Chris_Student]

Try this:


SELECT userid FROM events
WHERE Last(description) = 'Checkin' or Last(description) = 'Checkout'
GROUP BY userid

[cd2sg]

Try this

SELECT userid FROM events
WHERE Last(description) like 'Check%'
GROUP BY userid