SELECT emp_num, emp_fname, emp_lname, emp_email, total FROM lgemployee JOIN (SELECT employee_id, Sum(line_qty) AS total FROM lginvoice i join lgline l ON i.inv_num = l.inv_num JOIN lgproduct p ON l.prod_sku = p.prod_sku JOIN lgbrand b ON b.brand_id = p.brand_id WHERE brand_name = 'BINDER PRIME' AND INV_DATE BETWEEN '01-NOV-11' AND '06-DEC-11' GROUP BY employee_id) sub ON emp.emp_num = sub.employee_id WHERE total = (SELECT Max(total) FROM (SELECT employee_id, Sum(line_qty) AS total FROM lginvoice i JOIN lgline l ON i.inv_num = l.inv_num JOIN lgproduct p ON l.prod_sku = p.prod_sku JOIN lgbrand b ON b.brand_id = p.brand_id WHERE brand_name = 'BINDER PRIME' AND INV_DATE BETWEEN '01-NOV-11' AND '06-DEC-11' GROUP BY employee_id));