title: Multiple SELECT statements in MySQL Query
body: <p>If I have the schemas:</p>
  <blockquote>
  <p>Type(a,b,c,d)</p>
  <p>Name(e, b, g)</p>
  </blockquote>
  <p>I am trying to find all the resulting Name's 'E' where the 'D' of the Type is greater than a number that we access using the shared 'B'.</p>
  <p>I am trying to understand how to have multiple SELECT statements such as:</p>
  <pre><code>SELECT e FROM Name WHERE b = (SELECT b FROM Type WHERE d &gt; 1);
  </code></pre>
  <p>Can someone explain the syntax error and how to do nested SELECT statements or do I have to join the two tables.</p>
  <p>Thanks</p>