I don't know a thing about SQL other than how to copy someone else's script <g>. So your response meant nothing to me.
>From his question it looked like he wanted to find those who were marked twins. Easy to find siblings with the same name - look in the Name List or Children's List! Finding individuals with multiple parents is a search in Legacy and you could add to that search to show Parent-Child Relationship (under "Where to look" select Relationship to Father and/or Relationship to Mother and select a relationship that you're looking for) There are a lot of searches in Legacy if you know how! The search feature is very powerful with use of multiple conditions, searching the Search List or adding to an existing one... Granted there are a couple of things still missing (I'd love to see a search of age equal to, before or after) but a lot of those I can do in GENViewer (the programmer is working on that to make it compatible with v8. For now, you can use a gedcom in GV). Sincerely, Sherry Technical Support Legacy Family Tree On Tue, Jul 8, 2014 at 8:11 AM, Ron Taylor <[email protected]> wrote: > Jay's original question was about which field in the database contained > the child status. That is why I provided a few SQL scripts that make use > of those fields in the database tables. I was aware of the methods > available in Legacy. If you try the scripts that I posted, you will find > functionality not available in Legacy such as finding siblings with the > same name, listing individuals with multiple parents including their > relationship to each parent. The third script can be modified to achieve > several other possibilities that are not in Legacy. I also have another > script that can find possible multiple births that have the child status > blank and help to get those child status fields set to Twin, Triplet, etc. > > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
