my table consists of two columns, NAME and YEAR. When the person visits, we record their name the current year. The queries I used/came up are in the trash. I initially used

select name,year

from visit

where not exists

(select name,year

from visit

where year=2007)

and now that I see what I did, I assume that I need to have a table of just names and link it to the visits table so tht I can get those in the name table that dont have a corresponding 2007 entry in the visits table. Any ideas on how ?