title: Inner Join in cassandra CQL
body: <p>How do I write subqueries/nested queries in cassandra. Is this facility is provided in CQL?</p>
  
  <p>Example I tried:</p>
  
  <pre><code>cqlsh:testdb&gt; select itemname from item where itemid = (select itemid from orders where customerid=1);
  </code></pre>
  
  <p>It just throws the following error -</p>
  
  <pre><code>Bad Request: line 1:87 no viable alternative at input ';'
  </code></pre>