title: postgreSQL inner join
body: <p>i have sql query</p>
  
  <pre><code>select * from "Roles"  Join "Users"  On "Roles".Role="Users".RoleId
  </code></pre>
  
  <p>it return error  column Roles.role does not exist</p>
  
  <p>query </p>
  
  <pre><code>select * from "Roles"  Join "Users"  On Roles.Role=Users.RoleId
  </code></pre>
  
  <p>return error missing FROM-clause entry for table "roles"</p>
  
  <p>how can i solve this problem? 
  i aways work  with ms sql</p>