table: people ----------------+--------------- gedcom | varchar(20) personID | varchar(22) lastname | varchar(127) firstname | varchar(127) ----------------+--------------- table: families ----------------+---------------+------------------ gedcom | varchar(20) | [SMI] familyID | varchar(22) | [example: F104] husband | varchar(22) | [example: I2106] wife | varchar(22) | [example: I736] marrdatetr | date | [0000-00-00] ----------------+---------------+------------------ 1. List pairs of husband and wifes that share family ID AND gedcom SORTED by marrdatetr