select qualifyByDistribution, qualifyByOperator from tbl_CRM_MarketingActivities where ownerId = and ownerType = and marketingActivityId = select participantId, partnerid as operatorId, partnerType from tbl_CRM_Participants where ownerId = and ownerType = and marketingActivityId = update tbl_CRM_Participants set qualified = where participantId = update tbl_CRM_Participants set qualified = 'Y' where ownerId = and ownerType = and marketingActivityId =