|
Rapport: ter Haar
Beschrijving:
Fout: De syntax van de zoekvraag voor dit rapport (ID: 1) is ongeldig, daarom kan het rapport niet worden gemaakt. Neem contact op met de beheerder via informatie@famterhaar.nl.
Zoekvraag: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,firstname, lastname,lastname, firstname,birthdate,birthplace,if(sex='M',families1.marrdate,families2.marrdate),if(sex='M',families1.marrplace,families2.marrplace),(if(sex='M',families1.wife,families2.husband)) as spouse,(if(sex='M',families1.wife,families2.husband)) as spouse,deathdate,deathplace,sex,suffix, 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 ((=) AND (tng_people.living != 1)) AND tng_people.gedcom = "tH" ORDER BY lastname,firstname,birthdate
Foutmelding: