Miscellany

        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


SELECT T1.husband as husband, T2.wife as wife, T1.gedcom , T1.familyID 
FROM tng_families AS T1 INNER JOIN tng_families AS T2 ON T1.familyID = T2.familyID ORDER BY T1.gedcom