SELECT
	personalergic.pcucodeperson,
	personalergic.pid,
	personalergic.daterecord,
	personalergic.drugcode,
	personalergic.informant,
	personalergic.dateupdate
FROM
	personalergic
WHERE
		personalergic.pcucodeperson IS NULL
OR 	personalergic.pid IS NULL
OR	personalergic.daterecord IS NULL
OR  personalergic.drugcode IS NULL
OR 	personalergic.informant IS NULL
OR  personalergic.dateupdate IS NULL
ORDER BY
		personalergic.pid;