UFN_ALL_UNACKNOWLEDGED_MEMBERSHIPS

CREATE function dbo.UFN_ALL_UNACKNOWLEDGED_MEMBERSHIPS()
    returns table
    as return

            select 
        REVENUE.ID 
      from 
        dbo.REVENUE              
        inner join dbo.REVENUESPLIT on REVENUESPLIT.REVENUEID = REVENUE.ID
            where 
        REVENUE.ID not in (select REVENUELETTER.REVENUEID from dbo.REVENUELETTER) and 
        REVENUESPLIT.TYPECODE = 2