title: Select, Join and Two Where Clauses - Results tab empty
body: <p>I created the following tables;</p>
  
  <pre><code>CREATE TABLE Section(
  SectionNo int NOT NULL PRIMARY KEY,
  Semester varchar(7) NOT NULL,
  CourseID varchar(8) NOT NULL FOREIGN KEY REFERENCES Course(CourseID),)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>CREATE TABLE Registration (
  StudentID int NOT NULL FOREIGN KEY REFERENCES Section(StudentID)
  StudentNo int NOT NULL FOREIGN KEY REFERENCES Section(SectionNo)
  Semester varchar(7) NOT NULL,)
  </code></pre>
  
  <p>My Section tables look like</p>
  
  <pre><code>SectionNo     Semester    CourseID
  2714           I-2008      ISM 4212
  2715           I-2008      ISM 4930
  </code></pre>
  
  <p>My Registration table looks like</p>
  
  <pre><code>StudentID     SectionNo     Semester
  38214          2714          I-2008
  54907          2714          I-2008
  54907          2715          I-2008
  </code></pre>
  
  <p>I now must create a view to show which students are enrolled in SectionNo 2714 and 2715. These section numbers 2714 and 2715 refer to a course name in another table, but I do not need that for this purpose or alternatively I could join three later.</p>
  
  <p>I created my query as follows</p>
  
  <pre><code>SELECT R.StudentID, S.SectionNo, S.CourseID
  FROM Registration AS R
  FULL OUTER JOIN Section AS S
  ON R.SectionNo = S.SectionNo
  WHERE S.CourseID = 'ISM 4212' AND 
  S.CourseID = 'ISM 4930';
  </code></pre>
  
  <p>My query results are empty as follows;</p>
  
  <pre><code>Results   Messages
    StudentID   SectionNo   CourseID
    No results shown
  </code></pre>
  
  <p>However I do know that I should have 3 rows in the results tab from the above table. If I do the select query with only one where clause(ie do the select query with where clause for SectionNo 4212 and 4930 separately the results show up. But I was hoping to do a select statement and show the results for the two section numbers together.</p>
  
  <p>Can anyone help me and tell me where I am going wrong. I tried all the various join types and still got no results.</p>
  
  <p>Thanks   </p>