select int.partnerid, int.partnertype, cdrdistributorid, fsp.firstname, fsp.lastname, fsp.email, case when int.partnertype = 'opr' then opr.companyname else cdr.cdr_dstname end as companyname, case when int.partnertype = 'opr' then opr.address else cdr.cdr_dstaddress1 end as address, case when int.partnertype = 'opr' then opr.address2 else cdr.cdr_dstaddress2 end as address2, case when int.partnertype = 'opr' then opr.city else cdr.cdr_dstcity end as city, case when int.partnertype = 'opr' then opr.state else cdr.cdr_dststate end as state, case when int.partnertype = 'opr' then opr.zipcode else cdr.cdr_dstzip end as zipcode from tbl_crm_interactions int with (nolock) left outer join tbl_opr_clientoperators opr with (nolock) on opr.operatorid = int.partnerid and int.partnertype = 'opr' left outer join tbl_cdr_distributors cdr with (nolock) on cdr.cdr_recordid = int.partnerid and int.partnertype in ('dst','cdr') left outer join tbl_fspro_members fsp with (nolock) on fsp.fspro_userid = int.contactid and fsp.ownerid = and fsp.fsl_tablecode = where int.ownerid = and int.ownertype = and int.interactionid = select dst.dstid, dst.dstname from tbl_cdr_distributors cdr with (nolock) inner join tbl_dst_distributors dst with (nolock) on dst.dstid = cdr.fsl_dstid where ownerid = and fsl_tablecode = and cdr_recordid =

Select Manufacturer

Cancel

Likely Distributor

Contact

Request Details?

Start Dt
Months
Cmnts

Items

Submit

Cancel