双连接是双浸这应该工作
select employee.EmployeeName, inv.count, int.count from employee join ( select InviterID, count(*) as count from referralgroup by InviterID ) as inv on employee.employeeID = inv.InviterID join ( select InterviewerID, count(*) as count from referralgroup by InterviewerID ) as int on employee.employeeID = int.InterviewerID
