L
longyp
Guest
Can't work this out..either very stupid or something funny going on.
I'll keep it simple.
2 tables (Users, Schedules)
User table has a field lookup to Schedules.
I want to retrieve all users not belonging to a specific Schedule. I have the schedule ID, so
select * from tblUsers where scheduleID<>MYID.
This does return the users not belonging to the schedule but does not return users who have not been assigned a schedule.
Anyone explain??
THankyou greatly.
I'll keep it simple.
2 tables (Users, Schedules)
User table has a field lookup to Schedules.
I want to retrieve all users not belonging to a specific Schedule. I have the schedule ID, so
select * from tblUsers where scheduleID<>MYID.
This does return the users not belonging to the schedule but does not return users who have not been assigned a schedule.
Anyone explain??
THankyou greatly.