UFN_SELECTION_CONSTITUENT_MULTIYEARDONOR

CREATE function dbo.UFN_SELECTION_CONSTITUENT_MULTIYEARDONOR()
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 = 'Multiple years donor'
)