How can I go about creating a statement like this:<BR><BR>I have a table "ItemGroups" which simply holds groups names.<BR><BR>GroupID<BR>GroupName<BR><BR>Then I have a table "Items" which holds the items.<BR><BR>GroupID<BR>ItemName<BR><BR>I need to delete all the groups in which there are no Items using them. What is the most efficient way to do this? I need to call this statement often.<BR><BR>Would something like this work?... (although I'm not sure if the WHERE gets processed before the join... so maybe not)<BR><BR>DELETE FROM ItemGroups<BR>LEFT OUTER JOIN Items ON ItemGroups.GroupID = Items.GroupID<BR>WHERE Items.ItemName is NULL<BR><BR>Or maybe a "WHERE EXISTS" kind of statement (which I'm not too sharp on)<BR><BR>Thanks guys, very much appreciated!!