MySQL Forums
Forum List  »  Newbie

Sql query help
Posted by: jason greenwood
Date: August 16, 2016 03:38PM

Good evening,
I'm hoping someone can assist me with this one as I'm tearing my hair out.
I've got an invoice table where I want to be able to pull from 3 different tables, company_id, child, and leaders. They are all linked by company name.
I've written the following which brings back data which appears to multiply itself for child and leaders results.
If I do this query just on the child or leader it works perfectly it's just when they are both together it gives me weird results.
Many thanks for taking time to look at this for me.

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

Options: ReplyQuote


Subject
Written By
Posted
Sql query help
August 16, 2016 03:38PM
August 16, 2016 04:06PM
August 17, 2016 09:19AM
August 17, 2016 09:35AM
August 17, 2016 10:37AM
August 17, 2016 12:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.