Help joining tables with a query.

Help joining tables with a query.

Hello, I just can't seem to wrap my head around this issue...

I am fairly new to Z analytics so sorry if this has already been solved before.

Table 1 called "Campaign" with thousands of rows
Campaign IDI
Campaign Name 
ID 1
First
ID 2
Second

I have another table called "Leads" with the generated campaign ID associated to each record with less than a thousand record

LeadCampaign ID
Email 1ID 1
Email 2ID 2

I am using:

SELECT 
"Campaign"."Campaign ID", 
        "Campaign"."Campaign Name", 
        COUNT("Leads"."campaignID")
FROM "Leads"
LEFT JOIN "Campaign" ON "Leads"."campaignID" = "Campaign"."Campaign ID"
GROUP BY
"Campaign Insights (Facebook Ads)"."Campaign ID", 
        "Campaign Insights (Facebook Ads)"."Campaign Name"

I have tried many different configurations but it either doesn't work OR it shows values WAY higher than it should...

For example

Here is the result of that query. it does what its expected, except that it is counting the amount of times the ID shows in BOTH tables rather than just counting how many times it shows on the SECOND "leads" table

Just for refference, the values in the third column should be as follows:

This was made just using the "Leads" table