Sweetstreet Incentive Contact Merge
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