select interactiondate, fsp.firstname as repfirst, fsp.lastname as replast, fsp2.firstname as contactfirst, fsp2.lastname as contactlast, int.disposition, intdst.cdr_dstname as distname, cdrname.cdr_dstname as cdrname, oprname.companyname as oprname, int.mileage, fsp.fspro_userid as repid, fsp2.fspro_userid as contactid, int.notes, int.partnerid, int.partnertype, int.cdrDistributorid, int.interactionpurposeid, pur.purposeName, int.thankYouSent, int.interactionMethod, fsp3.fspro_userid as additionalResourceId, fsp3.firstname as additionalResourceFirst, fsp3.lastname as additionalResourceLast, case when int.partnertype = 'opr' then oprname.address else cdrname.cdr_dstaddress1 end as address, case when int.partnertype = 'opr' then oprname.city + ' ' + oprname.state + ', ' + oprname.zipcode else cdrname.cdr_dstcity + ' ' + cdrname.cdr_dststate + ', ' + cdrname.cdr_dstzip end as citystatezip from tbl_crm_interactions int with (nolock) left outer join tbl_fspro_members fsp with (nolock) on fsp.fspro_userid = int.dispositionuserid left outer join tbl_fspro_members fsp2 with (nolock) on int.contactid = fsp2.fspro_userid left outer join tbl_cdr_distributors intdst with (nolock) on intdst.cdr_recordid = int.cdrDistributorid left outer join tbl_opr_clientoperators oprname with (nolock) on oprname.operatorid = int.partnerid and int.partnertype = 'opr' left outer join tbl_cdr_distributors cdrname with (nolock) on cdrname.cdr_recordid = int.partnerid and int.partnertype in ('cdr','dst') left outer join tbl_crm_interactionpurposes pur with (nolock) on pur.purposeid = int.interactionpurposeid left outer join tbl_fspro_members fsp3 with (nolock) on fsp3.fspro_userid = int.additionalResourceUserId where int.ownerid = and int.ownertype = and int.interactionid = select * from qryPurposes union select * from qryPurposesInactive