The report would need one instance of the Title table and two instances of the SPCode table. Link/join the MarketingRep field to one instance and the BuyersAttorney field to the other instance. If the two Title fields are not required, ie one or both can be null, make sure you use Left Joins.