title: Convert Sub Query to a Join
body: <p>Hi is it possible to convert this sub query to a join ?</p>
  
  <pre><code>SELECT staff_no
  FROM doctor
  WHERE NOT EXISTS (SELECT *
                    FROM patient
                    WHERE staff_no = consultant_no);
  </code></pre>