select *
from tbl_fspro_members a, qryFSE_Companies b
where 1 = 1
and a.email like '%#form.email#%'
and a.firstname like '%#form.first#%'
and a.lastname like '%#form.last#%'
and a.fspro_userid = '#val(form.userid)#'
and a.ownerid *= b.companyid
and a.fsl_tablecode *= b.companytype
Total Records: #qcf_member.recordcount#
| ID |
First |
Last |
Email |
Password |
Owner |
Type |
CompanyName |
Directory |
Locked Password |
| #fspro_userid# |
#firstname# |
#lastname# |
#email# |
#fspro_password# |
#ownerid# |
#fsl_tablecode# |
#companyname# |
StaffContacts |
YESNo |