This may be in here and I just don't know how to word it.
I have a table about document filing (document numbers, titles, owners, etc.). It is related to a table of events that have happened to the documents (moved, changed ownership, etc.). So when I join the tables, results can be like: 3 rows for document #1 because it has had 3 events; 6 rows for document #2 because it has had 6 events, etc. This database has about 300,000 events recorded. I need to find the documents that do not have any event types "5".
Help is appreciated!