Left Outer Join SQL

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)

strSQL = "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)"