Help: Finding not exists

pakcik_kantin · #1 (**permalink**) 08-07-06, 01:31

Dear all
i have 2 tables users and logs. Logs keeps all the user logins; only when user logged in , it will be saved in this table.

How do i find users that have not logged in certain days , example:
Robert does not logged in on 24-JUL-2006.

Table users
userid
name

Table logs
userid
action_time

Tq

r937 · #2 (**permalink**) 08-07-06, 06:38

Code:

select users.name
  from users
left outer
  join logs
    on logs.userid = users.userid
   and logs.action_time = '2006-07-24'
 where logs.userid is null

pakcik_kantin · #3 (**permalink**) 08-07-06, 21:20

Thanks alot r937
It works.

Internet Services

Web Development

Digital Marketing

Consumer Tech