UFN_SELECTION_CONSTITUENT_NONDONORSUPPORTER

CREATE function dbo.UFN_SELECTION_CONSTITUENT_NONDONORSUPPORTER()
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 = 'Non-donor supporter'
)