Hello,
Since this would seem to be an easy question, I'll assume it's been
answered here before. On a site of mine, every time someone logs in,
authenticating against 'Users', a record is inserted into a table
called 'UserLog'. The two tables below represent the basic structure
of what I'm working with.
Table: Users
--------------------------
ID | Username | Password |
--------------------------
1 | syeargin | testpass |
2 | rdoe | passwd |
3 | jdoe | demo |
4 | jking | passwd |
5 | badams | demo |
--------------------------
Table: UserLog
-------------------------------------
ID | Username | LoggedIn |
-------------------------------------
1 | rdoe | 2004-08-24 12:16:33 |
2 | syeargin | 2004-08-24 12:14:33 |
3 | rdoe | 2004-08-24 12:16:33 |
4 | jking | 2004-08-24 12:16:33 |
6 | jking | 2004-08-24 12:16:33 |
-------------------------------------
My goal is to create a query that returns:
RecordSet: NoLogin
---------------
ID | Username |
---------------
3 | jdoe |
5 | badams |
---------------
My native language for the web site is PHP, but I think I've got a
handle on any other coding needs. All I need is a query.
Thanks in advance,
______________________
Stephen Yeargin
ye*******@hotmail.com