title: Select from table with composite primary key
body: <p>I have an injection table called <code>StudentSchool</code> that contains :</p>
  
  <pre><code>StudentSchoolID  StudentId   SchoolID
  1                233         22
  </code></pre>
  
  <p>But now I want to make the table with composite primary key like this:</p>
  
  <pre><code>StudentId   SchoolID
      233         22
  </code></pre>
  
  <p>In the first case I select using </p>
  
  <pre><code>select * from StudentSchool  
  where (StudentId = 233) and (SchoolID = 22)      
  </code></pre>
  
  <p>but in the second case how to do that with it as it is a primary key </p>