Sql query help
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,
Subject
Written By
Posted
Sql query help
August 16, 2016 03:38PM
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.