title: select the records only if ALL related records match
body: <p>Again I am stuck with a query.
  I want to select all records from table1 in which ALL related table2 records satisfy a condition.
  Only when the ALL table 2 records satisfy it.</p>
  
  <p>I tried this. But it's not working.</p>
  
  <pre><code>select m.* from table1 m
   inner join table2 I on m.Id = I.Id
  where 
  I.Id = ALL (select t.Id from table2 t where t.Id = I.Id and t.Status = 3)
  </code></pre>