如何在不给出相同输出的情况下组合这两个查询?
第一个查询是:
select vwemployee.directorateName , count(vwemployeeCourse.employeeId) as t1
from vwemployee , vwemployeeCourse
where vwemployee.directorateName = vwemployeeCourse.directorateName
GROUP BY vwemployee.directorateName
这是第二个查询:
select vwemployee.directorateName