SELECT
	personchronic.pcucodeperson,
	personchronic.pid,
	personchronic.chroniccode,
	personchronic.datefirstdiag,
	personchronic.datedxfirst,
	personchronic.typedischart,
	personchronic.cup,
  personchronic.hospfirstdiag,
	personchronic.dateupdate
FROM
	personchronic
WHERE
	personchronic.chroniccode IS NULL
OR personchronic.typedischart IS NULL
OR personchronic.dateupdate IS NULL
ORDER BY
	personchronic.pid;