Select emp.Employee_ID, emp.Last_Name,emp.First_Name,emp.Email,emp.Securityquestionid,emp.Answer,emp.Password,sec.SecurityQuestion from #Request.prefix_db_lookup#.Employee emp LEFT OUTER JOIN #Request.prefix_db_lookup#.security sec on emp.Securityquestionid = sec.SecurityID where Employee_ID=#Session.EmployeeId# Select SecurityQuestion from #Request.prefix_db_lookup#.security ORDER BY SecurityQuestion

Profile

First Name

#GetP.First_Name#

Last Name

#GetP.Last_Name#

#GetP.Email#

Security Question

#GetP.SecurityQuestion# #trim(GetP.Answer)#