Oldenburg Duchy Germany Search for Clemens Fortmann

Description: Parishes searched for surname: Fortmann, 1820's....
Findings: LOHNE, Fortmann's..... FOUND....2 FARMS........
VECHTA, Fortman's 2 MORE FARMS
FRIESOYTHE, no Fortmann Surnames....
WILDESHAUSEN, no Fortmann Surnames....
OLDENBURG, no Fortman Surnames....
VACHTA, no Fortman Surnames for 1805 or 1820's....
BAKUM, no Fortman Surnames for 1805 or 1820's....
STEINFELD, Fortmann Surnames but no match to family....
DAMME, to be researched....
HOLDORF, to be researched....

Home Search Search Print Print Login - User: anonymous Login Add Bookmark

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

Query: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,birthplace,lastname, firstname,birthdate,if(sex='M',families1.marrdate,families2.marrdate),deathdate, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) WHERE ((lastname = Fortmann birthplace = Germany) AND tng_people.living != 1) ORDER BY birthplace,lastname,firstname,birthdate,if(sex='M',families1.marrdate,families2.marrdate),deathdate
Error Message:

Report: Oldenburg Duchy Germany Search for Clemens Fortmann