# table: tng_people # ----------------+--------------- # gedcom | varchar(20) # personID | varchar(22) # lastname | varchar(127) # firstname | varchar(127) # ----------------+--------------- # # table: tng_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