UFN_SELECTION_CONSTITUENT_GIFTSPONSORSHIPRECIPIENTS

CREATE function dbo.UFN_SELECTION_CONSTITUENT_GIFTSPONSORSHIPRECIPIENTS()
returns table
as return
    select distinct SPONSORSHIP.CONSTITUENTID ID
    from dbo.SPONSORSHIP
    inner join dbo.REVENUESPLIT on REVENUESPLIT.ID = SPONSORSHIP.REVENUESPLITID
    inner join dbo.REVENUE on REVENUE.ID = REVENUESPLIT.REVENUEID
    where SPONSORSHIP.STATUSCODE = 1
    and SPONSORSHIP.CONSTITUENTID <> REVENUE.CONSTITUENTID;