title: How to get all fields except one with inner join?
body: <p>I am using MS Sql server and I have 2 tables as below;</p>
  
  <pre><code>School(scid, name, address, ....)
  Student(scid, studentName, studentSurname, ....)
  </code></pre>
  
  <p>What I want to query is;</p>
  
  <pre><code>SELECT * FROM Student ST INNER JOIN School SC ON ST.scid = SC.scid;
  </code></pre>
  
  <p>But I don't want to get double scid field as result(It returns scid and scid_1). I mean</p>
  
  <pre><code>SELECT *(except School.scid) FROM Student ST INNER JOIN School SC ON ST.scid = SC.scid;
  </code></pre>
  
  <p>Is there a way to get all fields except one?</p>