Something

        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

Nightmare query attempt:
SELECT T1.husband as husband, T2.wife as wife, T1.gedcom, T2.gedcom, T1.familyID, tng_people.gedcom 
FROM tng_families AS T1, tng_people INNER JOIN tng_families AS T2 ON T1.familyID = T2.familyID
WHERE T1.gedcom=tng_people.gedcom
ORDER BY T1.gedcom