How to display which user not mapped course table in courseusermapping table

I have a Course Table which is common for all user to select their related course and saved them in CourseUserMapping Table. Now my requirement is i want to display all courses which user not selected in course Table and hide selected courses list.

select c.* from Course c full outer join CourseUserMapping cum on c.CID = cum.CID
where c.CID is NULL Or cum.CID is NULL and cum.UserID='u3'

About me

Recent Questions

I am hosting my website on PythonAnywhere.
I have two databases on the service: myusername$production and myusername$dev.
The production db backs itself up every night and loads the dev database with the most recent batch of live data. I am tryin...

There are multiple files in /opt/dir/ABC/ named allfile_123-abc allfile_123-def allfile_123-ghi allfile_123-xxx.
I need the files to be named new_name-abc.pgp new_name-def.pgp new_name-ghi.pgp new_name-xxx.pgp and then moved to /usr/tst/output
for ...

I'm trying to save some XML(UBL) documents into Marklogic 8 with date formatting incorrect like this:
<cbc:IssueDate>2017-06-32</cbc:IssueDate>
I'm using Java API to save it but can't save because of the next exception:
Server Mess...

In my project I want to manage 3 repositories:
PARENT
CHILD1
CHILD2
The reason I'm not using only one PARENT repository that contains CHILD1+CHILD2 is that CHILD1\2 can be used in other projects also.
In a specific stage I want to tag all 3 reposi...

Although there are several similar questions here (e.g., SVN - Reintegration Merge error: "must be ancestrally related") and on the Web, I wasn't able to figure out why svn mergeinfo <file> causes an error in all of my SVN repositories. In cont...