title: How to do a join queries with 2 or more tables in cassandra cql
body: <p>I am new to cassandra. Here I have two tables <code>EVENTS</code> and <code>TOWER</code>. I need to join those for some queries. But I'm not enable to do it. </p>
  
  <p>Structure of <code>EVENTS</code> table:</p>
  
  <pre class="lang-sql prettyprint-override"><code>eid int PRIMARY KEY,
  a_end_tow_id text,
  a_home_circle text,
  a_home_operator text,
  a_imei text,
  a_imsi text,
  </code></pre>
  
  <p>Structure of <code>TOWER</code> table:</p>
  
  <pre class="lang-sql prettyprint-override"><code> tid int PRIMARY KEY,
   tower_address_1 text,
   tower_address_2 text,
   tower_azimuth text,
   tower_cgi text,
   tower_circle text,
   tower_id_no text,
   tower_lat_d text,
   tower_long_d text,
   tower_name text,
  </code></pre>
  
  <p>Now, I want to join these table with respect to <code>EID</code> and <code>TID</code> so that I can fetch the data of both tables.</p>