Re: Sql query help

[jason greenwood]

Peter,
Your amazing that's great, that works. I didn't put in the query I should have copied which also includes another table named leader. Is this just as easy to add a further statement or coma after the join? This is what it should have looked like DOH I'm sorry.

SELECT
Company_id.Company_name,
COUNT(child.Counting) AS `COUNT(Counting)`,
COUNT(leader1.Counting) AS `COUNT(Counting)1`
FROM company_id
INNER JOIN child ON company_id.Company_name = child.company
INNER JOIN leader1 ON company_id.Company_name = leader1.company
GROUP BY company_id.Company_name