>All I want to do is hav an SQL statement that gets a list of items from the main item table,but not list items already selected in the other table.
>
>Any ideas?
>Mike

You can either use a subquery:

select * from Table1;
  where KeyField not in (select KeyField from Table2)

Or do an outer JOIN, in which case the non-matching records have null values:

select Table1.KeyField, Table2.FieldX, Table2.FieldY;
  from Table1 left join Table2 on Table1.KeyField = Table2.KeyField;
  where isnull(Table2.KeyField)