select i.partnerId, i.partnerType, isd.saleSubjectId, i.dispositionUserId
from tbl_CRM_interactions i
left outer join tbl_CRM_interactionSaleDetails isd
on isd.interactionId = i.interactionId
where i.interactionId =
and i.ownerId =
and i.ownerType =
and isd.saleSubjectType = 'SKU'--->