Report: sources with notes, including note contents
Jump to navigation
Jump to search
Description: sources with notes, including note contents
Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate
SELECT sourceID, title AS Long_title, xn.note, s.gedcom FROM tng_notelinks AS nl LEFT JOIN tng_sources AS s ON (nl.persfamID=s.sourceID AND nl.gedcom=s.gedcom) LEFT JOIN tng_xnotes AS xn ON (nl.xnoteID=xn.ID AND nl.gedcom=xn.gedcom) WHERE (NOT ISNULL(sourceID)) AND nl.secret=0 ORDER BY title