select ownerid, fsl_tablecode as ownertype, staffmember, imageid, fspro_userid, 'STF'+ CAST(fspro_userid as varchar) + ' ' + firstname + ' ' + lastname as subjectDescription from tbl_fspro_members where fspro_userid = SELECT fsc.ContentID, fsc.MainFolder, fsc.SubFolder, fsc.FileName FROM tbl_FSC_Content fsc, tbl_FSPro_Members mems WHERE mems.OwnerID = AND mems.FSL_TableCode = AND mems.ImageID = fsc.ContentID AND mems.FSPro_UserID = #url.userId# delete from tbl_FSC_Content where contentid = and contentId <> 755 UPDATE tbl_FSPro_Members SET ImageID = 755 WHERE FSPro_UserID = AND OwnerID = AND FSL_TableCode =