SELECT
	persondeath.pcucodeperson,
	persondeath.cdeatha,
	persondeath.deadcause,
	persondeath.deaddate,
	persondeath.deadplace,
	persondeath.dateupdate,
	person.idcard,
	persondeath.pid
FROM
	persondeath
INNER JOIN person ON person.pid = persondeath.pid
WHERE
	persondeath.pcucodeperson IS NULL
OR persondeath.cdeatha IS NULL 
OR persondeath.cdeatha LIKE 'S%'
OR persondeath.cdeatha LIKE 'T%'
OR persondeath.cdeatha LIKE 'Z%'
OR persondeath.deadcause IS NULL
OR persondeath.deaddate IS NULL
OR persondeath.deadplace IS NULL
OR persondeath.dateupdate IS NULL
ORDER BY
	persondeath.pid;

