select operatorId, dateCreated, lastImportSource, freshnessDate from tbl_OPR_ClientOperators where ownerId = and fsltablecode = and crmActive = 'Y' and nullif( freshnessDate, '' ) is null select interactionDate from tbl_CRM_Interactions where ownerId = and ownerType = and partnerId = and partnerType = 'OPR' update tbl_OPR_ClientOperators set freshnessDate = where ownerId = and fsltablecode = and operatorId =