SELECT LOAD_STER.LOAD_ID, LOAD_STER.CREATED_DATE, LOAD_STER.END_DATE, LOAD_STER.CYCLE_NO, LOAD_STER.STERILIZER_EQ_NO, COUNT(LOAD_CONTENT.ASID) AS NUMBER_OF_TRAYS, USERS.NAME AS USER_NAME, USERS.USER_ID , PROCESS.NAME AS PROCESS_NAME, STERILIZER_EQUIPMENT.NAME AS STER_NAME, STERILIZER_EQUIPMENT.LOC_NO AS STER_LOCATION, LOCATION.NAME AS STER_LOCATION_NAME, COMPANY.DESCRIPTION AS FACILITY_NAME, COMPANY.COMPANY_NO AS FACILITY_NO FROM LOAD_STER, USERS, PROCESS, STERILIZER_EQUIPMENT, LOAD_CONTENT, LOCATION, COMPANY WHERE LOAD_STER.CREATED_BY = USERS.USER_ID AND LOAD_STER.PROC_NO = PROCESS.PROCESS_NO AND LOAD_STER.STERILIZER_EQ_NO = STERILIZER_EQUIPMENT.STERILIZER_EQ_NO AND LOAD_CONTENT.LOAD_ID = LOAD_STER.LOAD_ID AND LOCATION.LOCATION_ID = STERILIZER_EQUIPMENT.LOC_NO AND COMPANY.COMPANY_NO = LOCATION.COMPANY_NO GROUP BY LOAD_STER.LOAD_ID, LOAD_STER.CREATED_DATE, LOAD_STER.END_DATE, LOAD_STER.CYCLE_NO, LOAD_STER.STERILIZER_EQ_NO, USERS.NAME, PROCESS.NAME, STERILIZER_EQUIPMENT.NAME, STERILIZER_EQUIPMENT.LOC_NO, USERS.USER_ID, LOCATION.NAME, COMPANY.DESCRIPTION, COMPANY.COMPANY_NO