title: Selecting multiple rows from specific categories in SQL
body: <p>I want to be able to run a report that will give me a list of all the items in the User Computer, Server, and Virtual Machine categories. </p>
  
  <p>I want to exclude all other categories from this report. </p>
  
  <p>I'm not quite sure what to write in order to achieve this, or where to put it.</p>
  
  <p>This is what I'm working with currently. I get an Error Code 1054: Unknown column for each of the categories though...</p>
  
  <pre><code>SELECT DISTINCT
  ASSET.NAME AS ASSET_NAME,
  ASSET_TYPE.NAME AS ASSET_TYPE,
  ASSET_TYPE.ASSET_CATEGORY AS CATEGORY 
  FROM ASSET, ASSET_TYPE
  WHERE ASSET_CATEGORY IN (SERVERS, USER_COMPUTER, VIRTUAL_MACHINE)
  ORDER BY ASSET.NAME; 
  </code></pre>
  
  <p><strong>EDIT:</strong> I made the suggested changes (from Codo), but now I'm getting 0 rows returned. Any further suggestions?</p>