JOINS to get all info with single qry
Say want Privilege Level, No. of Logins
tblSecurity (1): UserID,Pswd,AdmLevel tblLogins (many): UserID, LoginDt
Join on UserID, and use aggregate fcns
MIN(AdmLevel) AS AdmLvl, MAX(LoginDt) AS LastLogInDt, COUNT(*) AS Hits
WHERE S.UserID = L.UserID AND S.userid = #form.user# AND pswd = #form.password#