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