[thelist] Genealogy database schema

Mike Migurski mike at saturn5.com
Thu Jan 2 17:21:01 CST 2003


er - shawn just reminded me that "union" is typically a reserved keyword
...  so, uh ... replace it with something more appropriate in the
following. :)

>select
>	person.id, union.member1 as father, union.member2 as mother
>from
>	union, person
>where
>	person.id=foo
>	and person.parents=union.id

---------------------------------------------------------------------
michal migurski- contact info and pgp key:
                 http://www.saturn5.com/mike/contact.html

                "Freedom! Horrible, horrible freedom!"







More information about the thelist mailing list