Report to show if ancestors of married couple were related...

[beun.net 0]

Some of the people in my tree who got married, appear to have (great)grandparents that are brothers or sisters.

In one specific case, there are two brothers. One of the two has a great grandson, and the other brother has a granddaughter.

This great grandson and granddaughter got married.

Is there a way to create a report that would show all married couples with ancestors that were related to each other?

Thanks :)

[beun.net 0]

Let's give this old thread a "kick" :)

[beun.net 0]

No one? :o

[svoght 0]

No one?

I think you've got your answer.

The problem here is that SQL queries (which are really what TNG reports are) are limited in terms of being able to find ill-defined connections. They're great at searching for specific things (e.g. 'find all the males with the first name 'John' born between 1800 and 1900') but can't really do the sort of multiple-hop recursive searching you want to do here. If you had a more well-defined problem (e.g. 'find any individuals who share a parent') it would be easy. This is the same reason the TNG relationship calculator can't handle complex connections between people, and that's using PHP in addition to SQL queries, which enables a lot more recursive searching!

You might have better luck using dedicated desktop genealogy software to do your relationship calculations -- they've got the horsepower and design to deal with those sorts of complexities.

[beun.net 0]

Didn't know this kind of query would be beyond MySQL.

Thanks for the explanation.