Rich, it looks to me like your SQL should work - I've never used
'!IN', always used 'NOT IN' instead, but that's not to say it won't
work.
I do note that you're missing the join criteria for your tables
classes, signups ...
Am I misunderstanding your question?
Dan
On 10/5/06, Rich <[EMAIL PROT
Hi folks. Any suggestions on the following?
If a student signs up for classes, I don't want them viewing those
classes so they can choose them again. So I want to take out their
'signups' from the master class list.
"select classnumber, classnumbersignup
from classes, signups
whe