UFN_SELECTION_CONSTITUENT_CONSECUTIVEYEARDONOR

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