Not pulling in course numbers

Question

1.00/5 (1 vote)

See more:

SELECT PS_STUDENTS.STUDENT_NUMBER AS [sourcedId], PS_U_STUDENTSUSERFIELDS.O365_EMAIL AS [username], PS_STUDENTS.FIRST_NAME AS [givenName], PS_STUDENTS.LAST_NAME AS [familyName], PS_U_STUDENTSUSERFIELDS.O365_EMAIL AS [email], PS_SCHOOLS.SCHOOL_NUMBER AS [orgs], PS_STUDENTS.STUDENT_NUMBER AS [password], "Student" AS role, PS_CC.Course_Number INTO StudentUsers
FROM ((PS_STUDENTS 
INNER JOIN PS_U_STUDENTSUSERFIELDS ON PS_STUDENTS.DCID = PS_U_STUDENTSUSERFIELDS.STUDENTSDCID) 
INNER JOIN PS_SCHOOLS ON PS_STUDENTS.SCHOOLID = PS_SCHOOLS.SCHOOL_NUMBER) 
INNER JOIN PS_CC ON PS_STUDENTS.ID= PS_CC.STUDENTID
WHERE PS_CC.COURSE_NUMBER="HS0321H" 
OR PS_CC.COURSE_NUMBER= "HS0363"
OR PS_CC.COURSE_NUMBER= "HS0363"
OR PS_CC.COURSE_NUMBER="HS0320H"
OR PS_CC.COURSE_NUMBER="HS0321H"
OR PS_CC.COURSE_NUMBER= "HS0362"
OR PS_CC.COURSE_NUMBER= "HS0360"
OR PS_CC.COURSE_NUMBER="HS0358S1"
OR PS_CC.COURSE_NUMBER="HS0359S2"
OR PS_CC.COURSE_NUMBER= "HS0346"
OR PS_CC.COURSE_NUMBER="HS0353S1"
OR PS_CC.COURSE_NUMBER="HS0353S2"
OR PS_CC.COURSE_NUMBER="HS0352"
AND PS_STUDENTS.SCHOOLID= 1050 OR PS_STUDENTS.SCHOOLID=1075
AND PS_STUDENTS.ENROLL_STATUS= 0
AND PS_CC.TERMID=3100;

Any Idea, Pulling in everything correctly except I want just these students that have this course number pulled in.

What I have tried:

Changed around parentheses and wording. Also pulling in duplicates.

Posted 5-Nov-21 5:49am

Anna Swanson

Updated 5-Nov-21 6:28am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-11-05T06:07:00

We cannot help you.
You need access to that code and yoru data - and we don't have access to the later.

So it's going to be up to you.
I'd start by looking at the data, and executing that query against it in SSMS to see exactly what it did return.
If it is nothing, then then remove the WHERE condition - just comment it out - and try again. What do you get this time?
If it's nothing, the problem in the Join(s) so start commenting them out until you find which one causes a problem.
If it's something, then it's the WHERE clause, or part of it, so start adding a bit back and see when it goes.

Then you can focus on the data and find out why - but we can't do any of that for you!

Luc Pattyn · Answer 2 · 2021-11-05T06:28:00

Solution 2

Operator Precedence (Transact-SQL) - SQL Server | Microsoft Docs[^]

AND takes precedence over OR, just like multiplication does over addition.
You'll need several parentheses to get what you want.

Posted 5-Nov-21 6:28am

Luc Pattyn

Updated 5-Nov-21 6:30am

v2