Jump to content
TNG Community

I need the gedcom field to join tables but dont want it to print


Horsman_ONS

Recommended Posts

Horsman_ONS

I need to use the people 'gedcom' [tree] field to join tables, but I dont want it to print.  If I delete the field from the fields to print the query falls over.

I have two trees in my installation,  but dont need to see the field on the report. it is used to pick up branches which are self explanatory.

Can anyone advise me?

 

Sue

 

SQL: SELECT 0156ab_people.personID,firstname,lastname,birthdate,birthplace, e4.eventdate as Occup_Date, e4.info as Occupation, burialdate,burialplace, b.description AS Branch, 0156ab_people.gedcom FROM (0156ab_people) LEFT JOIN 0156ab_branches as b ON (0156ab_people.branch =b.branch) LEFT JOIN 0156ab_events e4 ON 0156ab_people.personID = e4.persfamID AND 0156ab_people.gedcom = e4.gedcom AND e4.eventtypeID = "4" WHERE ( (e4.info LIKE "%Vicar%" OR e4.info LIKE "%curate%" OR e4.info LIKE "rector%" OR e4.info LIKE "%clergyman%") AND (0156ab_people.living != 1) AND (0156ab_people.lastname LIKE "HORS%")) ORDER BY firstname,lastname

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...