Christian,

Try isnull() instead of value=null

SELECT Item.Item
FROM Item LEFT JOIN BOM ON Item.Item = BOM.ItemParent
WHERE isnull(BOM.ItemParent);
GROUP BY Item.Item;