Eclipselink generates
SELECT t1.ID FROM CHILD t0, PARENT t1 WHERE ((t0.PARENT_ID IS NULL) AND (t0.PARENT_ID = t1.ID))
which looks very similar to what hibernate generates and is equally wrong.