两个表的连接问题

双连接是双浸这应该工作

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