UFN_SELECTION_CONSTITUENT_MIDLEVELDONOR

CREATE function dbo.UFN_SELECTION_CONSTITUENT_MIDLEVELDONOR()
returns table
as return
(      
    select 
        CONSTITUENTID as ID
    from 
        dbo.REVENUELIFECYCLE
        inner join dbo.LIFECYCLETYPE on LIFECYCLETYPE.ID = REVENUELIFECYCLE.LIFECYCLETYPEID 
    where
        LIFECYCLETYPE.LIFECYCLEGROUPCODE = 0 and
        LIFECYCLETYPE.NAME = 'Mid-level donor'
)