title: How to do WHERE clause BEFORE INNER JOIN
body: <p>How I do query like this ?</p>
  
  <pre><code>select Distinct  Station  , Slot , SubSlot, CompID , CompName 
  from DeviceTrace as DT DT.DeviceID = '1339759958' 
  inner join CompList as CL  
  where  and DT.CompID = CL.CompID
  </code></pre>
  
  <p>I need to do <code>DT.DeviceID = '1339759958'</code> before I start with the inner join. 
  I work with sql server. </p>