>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

select T1.* from myTable T1 where not exists (select 1 from AnotherTable T2 where T2.ID = T1.ID)

Take a look also here

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#4