SQL QUERY-多个COUNT返回错误（相同）的结果(SQL QUERY- multiple COUNT returns wrong (same) results)

 如何结合这两个查询而不给我相同的输出？ 
 
 第一个查询是： 
 
select   vwemployee.directorateName   , count(vwemployeeCourse.employeeId) as t1 

from vwemployee , vwemployeeCourse 

where  vwemployee.directorateName = vwemployeeCourse.directorateName 

GROUP BY vwemployee.directorateName
 
 这是第二个查询： 
 
select vwemployee.directorateName , count(vwemployee.directorateName) as t2 

from vwemployee , employeeCourse

where vwemployee.Id = employeeCourse.employeeId 

GROUP BY  vwemployee.directorateName
 
 我将使用组合查询生成报告 
 
 第一栏是董事会的名称 
 
 顺便说一下，当我把它们结合起来时，我的自我t1和t2有相同的结果但是当它们分开时它给了我正确的结果 
 
 
 
 t1栏应该显示这个特定董事会的课程数量，而t2栏应该显示这个董事会下这个课程的人数 
 
 
 因此，组合查询的表的总列数应为3列 
 

how to combine this two queries without giving me the same output ?
 
the first query is :
 
select   vwemployee.directorateName   , count(vwemployeeCourse.employeeId) as t1 

from vwemployee , vwemployeeCourse 

where  vwemployee.directorateName = vwemployeeCourse.directorateName 

GROUP BY vwemployee.directorateName
 
this is the second query :
 
select vwemployee.directorateName , count(vwemployee.directorateName) as t2 

from vwemployee , employeeCourse

where vwemployee.Id = employeeCourse.employeeId 

GROUP BY  vwemployee.directorateName
 
i will be using the combined query to generate a report 
 
the first column is the name of the directorate 
 
by the way when i combined them my self t1 had the same result as t2 but when they are separate it gave me the right result
 
 
 
the t1 column should display how many courses this specific directorate took , and t2 column should display how many employee's under this directorate took this courses
 
 
so the total columns of the table of the combined query should be 3 columns
 

原文：https://stackoverflow.com/questions/37185395