Filter unrelated rows

Question

I have 2 tables

TABLE 1 (named)  coursescores
studentCode,CourseCode,Garde,MajorCode,Score

TABLE 2 (named) MajorCourses
MajorCode,CourseCode,...

I want to fetch CourseCodes that are not related to Majorcode in TABLE 1 based on refrence table that is

MajorCourses

i want to get those coursecodes that are unrelated to majorcode in table 1

can anybody help me write the query thanks in advance

Please provide sample data and desired results, as tabular text. — GMB, Dec 04 '20 at 22:02

score 1 · Accepted Answer · answered Dec 04 '20 at 22:03

1

I think you want not exists. That would look like:

select cs.*
from coursescores cs
where not exists (
    select 1 
    from majorcourses mc 
    where mc.coursecode = cs.coursecode and mc.majorcode = cs.majorcode
)

answered Dec 04 '20 at 22:03

GMB

216,147
25
84
135

thanks GMB it was a great help and save my time – bahador arghavan Dec 04 '20 at 22:15

Filter unrelated rows

1 Answers1