spGetNetAccountRelations_Blocked

CREATE PROCEDURE dbo.spGetNetAccountRelations_Blocked
    (
    @NetAccountID int
    )
    AS
    BEGIN

    --This will return all my blocked relationships 

    SELECT 

    ID,
    RelationAccountID 'FriendAccountID',
    Confirmation,
    ConfirmationDate,
    BlockedID,
    CreateDate,
    UpdateDate

    FROM [NetAccountRelation] 
    WHERE

    NetAccountID = @NetAccountID 
    AND 
    BlockedID > 0

    UNION 

    SELECT 

    ID,
    NetAccountID 'FriendAccountID',
    Confirmation,
    ConfirmationDate,
    BlockedID,
    CreateDate,
    UpdateDate

    FROM [NetAccountRelation] 
    WHERE

    RelationAccountID = @NetAccountID 
    AND 
    BlockedID > 0

    END