Double LEFT OUTER JOIN

SELECT DISTINCT i.ItemId

FROM Item AS i

LEFT OUTER JOIN ModifierItem AS m

ON i.ItemId = m.ItemId

LEFT OUTER JOIN SubMenuItem AS s

ON i.ItemId = s.ItemId

WHERE (m.ItemId IS NULL) AND (s.ItemId IS NULL)