title: Querying SQL for user permission
body: <p>I have a database that stores usernames and permission that I need to query to get a list of users and their associated permission. It appears that they are both stored in two tables (dbo.user and dbo.[permission set]), but I can't seem to figure out how to query so that I get the following results:</p>
  
  <pre><code>User 1, perm 1
  User 1, perm 2
  User 2, perm 1
  user 2, perm 3
  </code></pre>