Hi,

I'm trying to write some admin screens for a site. I have a table which relates to two others showing courses subscribed for users. Each user can be subscribed to each course only once. In order to provide a suitable admin screen(s) for this, I would like the administrator to be able to see two lists - one listing the courses subscribed for that user and the other showing only the remaining courses available. Each item in the list could be a link and thus be able to add and remove subscribed courses in this way. I cannot get my head around writing the SQL for this, especially 'every course in the courses table minus the courses subscribed to in the subscription table for a particular user'. I'm using MySQL 3.23 and so do not have the benefit of views or stored procedures.

Any ideas or advice?

Thanks,

Simon