Thursday, February 02, 2006

Double LOJ #2


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