select interactiondate, partnerid, partnertype, contactid, mileage, notes, interactionpurposeid, thankYouSent,
interactionMethod
from tbl_crm_interactions
where interactionid =
and ownerid =
and ownertype =
select fspro_userid, firstname, lastname, title
from tbl_fspro_members
where ownerid =
and fsl_tablecode =
and orgid =
and orgtype =
order by lastname
select * from qryPurposes
union
select * from qryPurposesInactive
order by sortrank, purposeName
select * from qryPurposes
order by sortrank, purposeName