UFN_SELECTION_CONSTITUENT_SPONSORS

CREATE function dbo.UFN_SELECTION_CONSTITUENT_SPONSORS()
returns table
as return
    select distinct SPONSORSHIP.CONSTITUENTID ID
    from dbo.SPONSORSHIP
    left join dbo.REVENUESPLIT on REVENUESPLIT.ID = SPONSORSHIP.REVENUESPLITID
    left join dbo.REVENUE on REVENUE.ID = REVENUESPLIT.REVENUEID
    where SPONSORSHIP.STATUSCODE = 1
    and (REVENUE.CONSTITUENTID is null or
         SPONSORSHIP.CONSTITUENTID = REVENUE.CONSTITUENTID);