how i can do this
consider 5 subjects : A, B, C, D and E.
subject A is the father of the subject B.
Subject C is the brother of the subject B.
subject D is the son of the subject B.
subject E is the son of the subject C.
Write a stored procedure that takes as parameters two of the 5 subjects and return their family kinship.