Home | What's New | Photos | Histories | Sources | Reports | Cemeteries | Headstones | Statistics | Surnames

 Report: Associations between people

         Description: Verbindingen tussen personen

HomeHome    SearchSearch    PrintPrint    Login - User: anonymousLogin    Add BookmarkAdd Bookmark

Error: The syntax of the query run with this report (ID: 239) was incorrect, and as a result the report could not be run. Please contact the system administrator at richard@curtisit.com.

Query: SELECT p.personID, p.lastname AS lastname1, p.firstname AS firstname1, p.birthdate AS born1, p.living AS living1, p.gedcom, a.relationship AS Association, p2.personID AS Person2, p2.lastname AS lastname2, p2.firstname AS firstname2, p2.birthdate AS born2, p2.living AS living2, p2.gedcom FROM tng_ass AS a LEFT JOIN tng_people AS p ON ( a.personID = p.personID AND a.gedcom = p.gedcom ) LEFT JOIN tng_people AS p2 ON ( a.passocID = p2.personID AND a.gedcom = p2.gedcom ) WHERE p.living <>1 AND p2.living <>1 ORDER BY p.lastname, p.firstname, p.birthdatetr
Error Message: