I have a table of users that looks like this:
USERS
userid | email | action | actiontimestamp
And another table of some user actions (login, logout, etc.) that looks like this:
USER_ACTIONS
actionid | userid | action | actiontimestamp
I need to be able to update the USERS table action and actiontimestamp values with a single query where it uses the latest row from the USER_ACTIONS table. Is this possible?