CREATE VIEW VU_FamilyGroup AS SELECT 
       Family.FamilyID,
       KID.FullName,     Child.PersonID,
       PRIME.FullName,   Family.PrimeID,
       PARTNER.FullName, Family.PartnerID
FROM   Child,
       Family,
       VU_FullName AS PRIME,
       VU_FullName AS PARTNER,
       VU_FullName AS KID
WHERE
       Child.FamilyID   = Family.FamilyID
   AND Child.PersonID   = KID.PersonID
   AND Family.PrimeID   = PRIME.PersonID
   AND Family.PartnerID = PARTNER.PersonID

ORDER BY Family.FamilyID;