title: show all Data from Permission Table
body: <p>I have 2 tables like that:</p>
  
  <pre><code>PermissionsTbl
  __________________
  PermissionID            int         NotNull
  PermissionDescription   nvarchar(100)   NotNull
  
  PermissionID      PermissionDescription 
  1             Human Resources
  2             Employees Data
  3             Departements
  
  ActivePermissionsTbl
  ________________________
  ActivePermID    bigint  NotNull
  PermissionID    int NotNull
  UserID          int NotNull
  PageActive  bit NotNull
  
  ActivePermID    PermissionID    UserID     PageActive        
  1           1           1      True
  2           2           1      True
  3           3           2      True
  </code></pre>
  
  <p>what I want is show data like that:</p>
  
  <pre><code>PermissionID      PermissionDescription   PageActive     UserID               
  1                 Human Resources         True           1
  2                 Employees Data          True           1
  3                 Departements                           1
  1                 Human Resources                        2
  2                 Employees Data                         2
  3                 Departements            True           2
  </code></pre>
  
  <p>I try several methods of Join , but I failed&lt; any suggestion please.
  Thanks. </p>