|
|
|
 |
 |
 |
|
resultaten 1 tot 2 van 2
| |
Omschrijving |
Aantekeningen |
Verbonden met |
Kan query niet uitvoeren: SELECT tng_doclinks.ID, tng_doclinks.personID as personID, people.living as living, nameorder, people.branch as branch, tng_families.branch as fbranch,
tng_families.living as fliving, people.lastname as lastname, people.lnprefix as lnprefix, people.firstname as firstname, people.suffix as suffix, tng_doclinks.gedcom,
treename, tng_sources.title, tng_sources.sourceID
FROM tng_doclinks, tng_trees
LEFT JOIN tng_people AS people ON tng_doclinks.personID = people.personID AND tng_doclinks.gedcom = people.gedcom
LEFT JOIN tng_families ON tng_doclinks.personID = tng_families.familyID AND tng_doclinks.gedcom = tng_families.gedcom
LEFT JOIN tng_sources ON tng_doclinks.personID = tng_sources.sourceID AND tng_doclinks.gedcom = tng_sources.gedcom
WHERE docID = "6" AND tng_doclinks.gedcom = tng_trees.gedcom ORDER BY lastname, lnprefix, firstname, personID
| |