SELECT w.auth_CustFldr, w.auth_AppName, w.auth_LoginSecureIDs, w.auth_ReminderSiteName, w.auth_ReminderFromAddy, w.auth_LoginHelpAddy, c.FSL_CompanyID, c.FSL_TableCode, w.websiteid, w.auth_GenericBrokerPortalLogin FROM tbl_CUS_Websites w, tbl_CUS_Customers c WHERE w.auth_clntCD = AND w.CustomerID = c.CustomerID client.CustFldr = trim(qmd_getLogWinVars.auth_CustFldr); client.OwnerID = qmd_getLogWinVars.FSL_CompanyID; client.ClientType = trim(qmd_getLogWinVars.FSL_TableCode); client.AppName = trim(qmd_getLogWinVars.auth_AppName); client.LoginAreaID = qmd_getLogWinVars.auth_LoginSecureIDs; client.RemindSiteName = trim(qmd_getLogWinVars.auth_ReminderSiteName); client.RemindFrom = trim(qmd_getLogWinVars.auth_ReminderFromAddy); client.LoginHelpAddr = trim(qmd_getLogWinVars.auth_LoginHelpAddy); client.websiteId = qmd_getLogWinVars.websiteid; client.GenericBrokerPortalLogin = qmd_getLogWinVars.auth_GenericBrokerPortalLogin;