select distinct t1.sku, t3.[itemName] as [HED.com Title], t2.title as [Amazon Scraped Title] from [AmazonTool].[dbo].[ResultsSKUMap] t1
inner join [AmazonTool].[dbo].[ItemLookupResults] t2
on t1.[ResultID] = t2.ID
inner join [AmazonTool].[dbo].[QueryBC] t3
on t1.sku = t3.sku
order by t1.sku