title: where exists SQL not working properly - H2 Db
body: <p>I am trying to select permissions that are only part of a specific permission group. They are binned together in a relational table. The way I am trying to this is by using WHERE EXISTS in a sub query.</p>
  
  <pre><code>select * 
  from permissions 
  where exists (select 'x' 
                from rel_sets_permission 
                where pset_id = :id);
  </code></pre>
  
  <p>The problem is that it seems like that if there is at least one occurrence of the id in the relational table, I will get as a result of main query all of the permissions.
  I need advice, as I have looked up the logic of the WHERE EXISTS and its purpose should be the case in which I use it.
  I am working with H2 database.</p>