Re: Help writing SQL query

"Barry Bulsara" <bbulsara23_at_hotmail.com> wrote in message news:1102447259.4791.0_at_lotis.uk.clara.net... >
> Daniel, I can't change the structure. I am not designing this, it is what
I
> have to work with, and I have to get the information into a proper
> structure.
> The reason I have chosen familymember1 and 2 and the contrived data is to
> make the explanation simple and hopefully get on the road to a simple
query.
> Regards
> Barry

It is NOT clear to this reader the relationship between familymember1 & familymember2;
other than somehow they are related to each other.

What gets reported for cases where more than TWO generations are in the table?

Why only TWO members in the table when every child has a mother and a father?
Dick marries Jane and have two kids John & Sue. John grows up, marries Sally and has Jeremy & Nadine. Sue grows up married Ted & has Samantha & Tyler. What's in your DB for this case & who gets reported as a "family"? Received on Tue Dec 07 2004 - 13:36:56 CST