SELECT *

FROM A

LEFT JOIN D ON A.id = D.id

WHERE D.id IS NULL;