title: Select from second table column based on result of select from different table
body: <p>I'm trying to use the result of querying one table to then use as my "where" for the 
  column of a second table. This is what I've been trying:</p>
  
  <pre><code>SELECT channel
  FROM shows
  WHERE ID ='36741'
  </code></pre>
  
  <p>This gives me a result of "Discovery". All the rows of "channels" on the table "shows" are columns on the table "cccservices". I then need to do the following:</p>
  
  <pre><code>SELECT service
  FROM cccservices
  WHERE Discovery='x'
  </code></pre>
  
  <p>I've tried this: </p>
  
  <pre><code>SELECT service
  FROM cccservices
  WHERE (Select channel from shows where ID='36741')='x'
  </code></pre>
  
  <p>but I'm sure I'm missing something. The ID is given to me by a user submitted form if that matters at all.</p>