UFN_RELATIONSHIP_GETCONSTITUENTS

create function dbo.UFN_RELATIONSHIP_GETCONSTITUENTS
(
    @RELATIONSHIPID uniqueidentifier
)
returns table
as
return
(
    select
        CONSTITUENT.ID as CONSTITUENTID,
        CONSTITUENT.ISORGANIZATION as CONSTITUENTISORG,
        CONSTITUENT.ISGROUP as CONSTITUENTISGROUP,
        RECIPROCALCONSTITUENT.ID as RECIPROCALCONSTITUENTID,
        RECIPROCALCONSTITUENT.ISORGANIZATION as RECIPROCALCONSTITUENTISORG,
        RECIPROCALCONSTITUENT.ISGROUP as RECIPROCALCONSTITUENTISGROUP,
        RELATIONSHIP.ISCONTACT as ISCONTACT
    from
        dbo.RELATIONSHIP
        left join dbo.CONSTITUENT on RELATIONSHIP.RELATIONSHIPCONSTITUENTID = CONSTITUENT.ID
        left join dbo.CONSTITUENT [RECIPROCALCONSTITUENT] on RELATIONSHIP.RECIPROCALCONSTITUENTID = RECIPROCALCONSTITUENT.ID
    where
        RELATIONSHIP.ID = @RELATIONSHIPID
)