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'
the above query is not working as i expected.
For better understand i created a picture