Hello,

I am trying to create a statement that will return plot numbers that don't exist in every five year period:

1965
1970
1975
1980.. etc until 2005

some of the plots don't exist anymore because they were clearcut or for some reason were not measured for that cycle. I read that a MINUS statement will allow me to see what rows in one table are not present in another, I'm just not sure how to construct it property to get what I am looking for. I have tried:
Code:
select plotnum from density
minus
select sampyear from density
;
I'll admit that I am still learning SQL but I am pretty sure this statement does not give me what I want. I tried something else like:
Code:
select plotnum from density
where plotnum <> plotnum
where sampyear in (1965,1970,1975,1980) */ etc...
;
If there are other resources to help me learn that anyone could refer me to that would be great as well. Thanks in advance,

Ladygray