I have the following tables:
In the third table I want to combine these data with the SUM option in SQL so the total of clicks and Sends are in one field. Like this:
I created the following query:
SELECT SUM(s.Sends) as [Sends], SUM(c.Click) as [Click], s.JourneyName FROM [Plus Tracking Journey Bounce] s join [Plus Tracking Journey Click] c on s.JourneyName = c.JourneyName GROUP BY s.JourneyName, c.JourneyName
As a result I got this:
It multiplies with 2 because there are two records in each table. I tried a different join but with no results. Is this even possible and if so, what do I miss.