Report: families: husbands

From TNG_Wiki
Jump to navigation Jump to search

Description: families: husbands

Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate

SELECT familyID, marrdate, h.personID, h.lastname, h.firstname, h.birthdate,, h.gedcom FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband=h.personID ORDER BY h.lastname, h.firstname, h.personID