When using multiple inner joins I get different results compared to when I use a single inner join
I am having trouble understanding why my two SQL queries output different results for the count of senior managers when I expected them to be the same. SELECT COMPANY.Company_Code, COMPANY.Founder, COUNT(SENIOR_MANAGER.Senior_Manager_Code) FROM COMPANY INNER JOIN SENIOR_MANAGER ON SENIOR_MANAGER.COMPANY_CODE = COMPANY.COMPANY_CODE GROUP BY COMPANY.COMPANY_CODE, COMPANY.FOUNDER; This SQL query is trying to find out how many senior […]