title: Query 1 table output same column twice with different filters showing what the other isn't
body: <p>I am trying to view the same column twice with different filters for each column.  Using SQL Server 08</p>
  
  <p>Ex:  In the column I'm calling DPO, I want to only show job codes abc and xyz . The column labeled Work Needed needs to show all but job codes abc and xyz.  </p>
  
  <p>Below is part of my query minus some tables to shorten it up, which is why I'm pulling from 3 tables.</p>
  
  <pre><code>SELECT 
  
  WkRoDesc.Job_Code AS [Work Needed], 
  WkRoDesc.Job_Code AS [DPO]
  
  FROM vhstock, WkInvReg, WkRoDesc
  
  WHERE vhstock.no = WkInvReg.Stock_No AND WkInvReg.Ro_Number = WkRoDesc.Ro_Number
  </code></pre>