Help with Count /Group By statement

It is too late in the afternoon to think clearly I guess, I need some help with a count() / group by statement.

A number of organizations participate in a program for employee exchange. Some employees will one day do the job of another employee in another organization. Each organization puts one or more jobs and one or more employees into the program. The jobs and employees must NOT be related (an employee can have a day vacation for example)

I want to display how many employees and how many jobs each organization has put into the program.


table [organization]
table [employee] with FK to organization
table [job] with FK to organization

this works, but only counts the employees

SELECT organization_id, organization_name, COUNT(participant_id) AS participant_count
FROM organization LEFT JOIN employee ON organization.organization_id = employee.organization_id
GROUP BY organization_id, organization_name


then this I want also the jobs counted, and I tried the following. But that does not give the right numbers, but muliplies the jobs with the employees for both "count" fields.

SELECT organization_id, organization_name, COUNT(participant_id)  AS participant_count, COUNT(job_id) AS job_count
FROM organization
    LEFT JOIN employee ON organization.organization_id = employee.organization_id
        LEFT JOIN job ON organization.organization_id = job.organization_id
GROUP BY organization_id, organization_name

How can I solve this?