title: Selecting records in SQL based on another table's contents
body: <p>I'm a bit new to SQL and have trouble constructing a select statement. I have two tables:</p>
  
  <pre><code>Table users
      int id
      varchar name
  
  Table properties
      int userID
      int property
  </code></pre>
  
  <p>and I want all user records which have a certain property. Is there a way to get them in one SQL call or do I need to first get all userIDs from the properties table and then select each user individually?</p>