You are viewing a single comment's thread. Return to all comments →
on
using
1 -
select c.company_code, c.founder, count(distinct lm.lead_manager_code), count(distinct sm.senior_manager_code), count(distinct m.manager_code), count(distinct e.employee_code) from Company c inner join Lead_Manager lm using (company_code) inner join Senior_Manager sm using (company_code) inner join Manager m using (company_code) inner join Employee e using (company_code) group by c.company_code, c.founder;
Seems like cookies are disabled on this browser, please enable them to open this website
New Companies
You are viewing a single comment's thread. Return to all comments →
Notes
on
, you can alternatively useusing
if the 2 columns have the same name.Solution
1 -