title: Eloquent Subquery
body: <p>I have a many to many relationship between a <strong>student table</strong> and a <strong>apparatus table</strong> (A student performs on many apparatuses and an apparatus has many students). I have a <strong>student_results table</strong> that has a composite primary key (<strong>student_id</strong> and <strong>apparatus_id</strong>) and a 3rd field called results).</p>
  
  <p>I have written a query to find all the apparatuses that a student <strong>DOES NOT</strong> have a result. The example I give is for student with id = 121. 
  The sub-query is.</p>
  
  <pre><code>SELECT apparatus_id, strapparatus_name FROM apparatuss 
  WHERE apparatus_id &lt;&gt; ALL(SELECT apparatus_id FROM student_results 
  WHERE student_id =' . 121 . ')';
  </code></pre>
  
  <p>I would like to write this using Eloquent (Laravel 4.1).</p>
  
  <p>Any help greatly appreciated.</p>