I don't seem to get it.

[BakMan]

The idea is : people need to check their passwords every <password_exiry>

I have 3 tables

1 table containing 3 fields ; hostID, hostname, password_expiry
1 table containing the users ; userID, username, password
1 table containing the last date the password was checked : checkedID, userID , hostID, last_date_checked

How can I build a query which is going to tell me when a host was never checked before ?


BaKMaN

 

[rac2]

If rows are only added to the password_checked_table when a password is checked then -

SELECT * FROM hosts_table
WHERE hostID NOT IN (
   SELECT DISTINCT hostID FROM password_checked_table)