Anonymous

SELECT case_services.id, (select top 1 case_services_staff.staff_id from case_services_staff where case_services.id=case_services_staff.service_id) AS First_Staff, (SELECT TOP 1 COUNT(case_services_staff.staff_id) FROM case_services_staff WHERE case_services_staff.service_ID = case_services.ID) AS Num_StaffFROM CASE_SERVICES