OK - I think I see where you are coming from but still not certain about the logic
I don't think it can be done with the data available - best I can come up with is
Code:
SELECT DISTINCT children.Child, fathers.Child, mothers.Child, children.Father, children.Mother
FROM (tblPeople AS children LEFT JOIN tblPeople AS fathers ON children.Father = fathers.Father) LEFT JOIN tblPeople AS mothers ON children.Mother = mothers.Mother;
which shows all the relationships, but I can see no logic for combining 'albert/teresa' with 'dave/teresa' and 'albert/blank' into one extended family - what if Stacy's mother was Tiara rather than Teresa? - would this mean that 'albert/teresa' would also be combined with 'Bob/Tiara' and 'Bob/Holly'?