Subject | KeyLinks, Join Links... Am I doing this right? |
---|---|
Author | Paul Irwin |
Post date | 2001-02-20T02:38:15Z |
Here's my scenario. I have a users table and a sessions table. The
sessions table will be frequently updated as users log in and out. I want
to display a grid of which users are currently logged in.
Table 1 - Sessions
Fields
Session_ID (PK)
User_ID (FK -> Users.User_ID)
Location
Start_Date
Table 1 - Users
Fields
User_ID (PK)
Login_Name
Login_Password
SQL - select Sessions.*, Users.Login_Name from Sessions, Users where
Users.User_ID = Sessions.User_ID;
KeyLinks
Sessions.Session_ID
JoinLinks
Users.User_ID = Sessions.User_ID
This setup works, but I'm not sure if this is as it should be. Thank you
for any input you have.
Paul
sessions table will be frequently updated as users log in and out. I want
to display a grid of which users are currently logged in.
Table 1 - Sessions
Fields
Session_ID (PK)
User_ID (FK -> Users.User_ID)
Location
Start_Date
Table 1 - Users
Fields
User_ID (PK)
Login_Name
Login_Password
SQL - select Sessions.*, Users.Login_Name from Sessions, Users where
Users.User_ID = Sessions.User_ID;
KeyLinks
Sessions.Session_ID
JoinLinks
Users.User_ID = Sessions.User_ID
This setup works, but I'm not sure if this is as it should be. Thank you
for any input you have.
Paul