USP_DATALIST_SCHOOLDEPARTMENTS

CREATE procedure dbo.USP_DATALIST_SCHOOLDEPARTMENTS
as
    set nocount on;

    select ACADEMICCATALOGDEPARTMENT.ID,
           CONSTITUENT.KEYNAME as SCHOOLNAME,
           ACADEMICCATALOGDEPARTMENT.NAME as DEPARTMENTNAME,
           ACADEMICCATALOGDEPARTMENT.USERID
    from dbo.SCHOOL
    join dbo.ACADEMICCATALOGDEPARTMENT on ACADEMICCATALOGDEPARTMENT.SCHOOLID = SCHOOL.ID
    join dbo.CONSTITUENT on CONSTITUENT.ID = SCHOOL.ID

    order by
        SCHOOLNAME,
        DEPARTMENTNAME