>Thanks, but I'm having a little trouble phrasing what I want. I believe you have answered that question. But I didn't explain what I want properly...
>Table one, is an item table and description. i.e. the two fields I'm using are itemkey, itemdesc
>Table 2 is a table listing grpitems, which stores a list of items in a group. where the itemkey in the grpitems table links to the item table.
>
>I have a group called Everyone. This is the group of items in the grpitems table that everyone can see.
>
>Let say that the group called lab is adding items that only the lab can see. (Items that are not in the everyone group.) To aid and reduce data errors, I would like to present to the data entry person who is adding items for the lab group, a list of items that do not include those selected for everyone. After all, they can already see them. So maybe the phrasing of my question is I want to present a list of items, not including those in the the everyone group. I basically want to filter out items that are in the everyone group from the list.
>
>Does this help?
>Mike

Same query as before but with an extra filter, e.g.

select I.* from Items It where not exists (select 1 from GrpItems GR where Gr.ItemKey = It.ItemKey and Gr.GroupName = 'EVERYONE')