I've been trying to get a query working that returns a list of users stored in my database, who last logged in over 90 days ago.
I've got this so far:
SELECT jobseekers.forename, jobseekers.surname, jslogin.email, jslogin.js_last_login FROM jobseekers, jslogin WHERE jslogin.js_last_login <= SUBDATE(NOW(), INTERVAL 90 DAY);
But when I run it I get an empty set, when there really should be some entries.
Am still a total newbie, but I hope its clear what I'm trying to do!!
Thank you in advance for any help.