select * from qmd_distributorOpportunities where opportunityId in ( ) union select * from qmd_overlapOpportunities select partnerId, partnerType, partnerName, opportunityId, opportunityName, subjectId, subjectType, durationUnit, sum( incomeAmt ) incomeAmt, sum( quantityAmt ) quantityAmt, sum( volumeImpact ) volumeImpact, sum( valueImpact ) valueImpact from qmd_opportunities group by partnerId, partnerType, partnerName, opportunityId, opportunityName, subjectId, subjectType, durationUnit