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 PROTECTED]> wrote:
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
where classnumber !IN (select classnumbersignup from signups where
userid = [$myID])
and mytype = 'yellow'";
I don't want to have to rely on middleware for this.
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
