Report: Marriages

         Description:


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 chris@cj2o.com.

Query: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,firstname, lastname,if(sex='M',families1.marrdate,families2.marrdate),(if(sex='M',families1.wife,families2.husband)) as spouse, 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 LIKE) AND tng_people.gedcom = "1" ORDER BY lastname
Error Message: