I have a small Genealogy Website that uses SQL
I have the following code to search one table for the following info:
SELECT id, lastname, firstname, birthdatetr, deathdatetr
WHERE (burialplace LIKE "%missouri%") AND (deathdatetr BETWEEN "1910-01-01" AND "1965-12-31")
ORDER BY lastname, firstname ASC
In another table "tng_media" column name "mediatype" I need to see if those selected in the above query have a "death Certificate" affiliated with them.
mediaID | mediatypeID | gedcom | form | path | description | placetaken | notes | owner | thumbpth | etc....
7574 | death |Cervenka1| JPG |Death Certificate - John Doe.jpg |Death Certificate - John Doe | | | | |