Creating a SELECT (or maybe MINUS statment)

[ladygray]

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:

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:

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

[ld_be]

Hello


Will this help you?

select plotnum from density
except
select plotnum from density
where sampyear in (1965,1970,1975,1980,1985,1990,1995,2000,2005)


Greetings
ld_be

[ld_be]

You can except chance in minus.

[ladygray]

Thank you very much... too bad there are so many plot numbers that weren't remeasured each cycle!! Over 2000!