[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