Sweetstreet Incentive Contact Merge
Name \ Email \ FSProUserID
SELECT m.*, s.memberid, s.ownerID ssd_ownerid, s.fsl_tableCode ssd_fsl_tableCode FROM fslibrary.dbo.tbl_FSPro_Members m INNER JOIN sweetstreet.dbo.tbl_SR_Members s ON s.fspro_userid = m.fspro_userid WHERE s.memberid > 0 AND (m.firstname LIKE OR m.LastName LIKE OR m.Email LIKE OR m.FSPro_UserID LIKE ) ORDER BY m.LastName, m.FirstName
FSProUserID Lastname Firstname Email Password Create Date SSD MemberID SSD OwnerID SSD FSL_TableCode KEEP Record DELETE Record
#getUserData.Fspro_UserID# #getUserData.Lastname# #getUserData.firstname# #getUserData.email# #getUserData.fspro_password# #dateformat(getUserData.createDate,"mm-dd-yyyy")# #getUserData.memberid# #getUserData.ssd_ownerid# #getUserData.ssd_fsl_tableCode#