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) " _
& "ORDER by i.ItemId"
No comments:
Post a Comment