HI,
Sorry for the previous reply. I did not read your second one before I replied you. Anyway, I tried it and I worked perfectly. So the IsNULL keyword mean the same than

NOT IN;
(SELECT Itemparent from BOM); ??

Interesting,
Thank you,
Christian