title: How to Write a sub query inside serverside datatables [ignited datatable]
body: <p>How to Write a sub query inside serverside datatables ,does anyone have any idea ?</p>
  
  <p>now we are following a method of ignited-datatables by ahmed-samy </p>
  
  <p>Here's reference link <a href="http://www.ahmed-samy.com/php-codeigniter-full-featrued-jquery-datatables-part-2" rel="nofollow">link</a>! </p>
  
  <pre><code>$this-&gt;datatables-&gt;select('C.cls_id,S.std_name,B.bat_name,SE.name,C.standard,C.batch,C.status');
   $this-&gt;datatables-&gt;join('standards AS S','S.std_id = C.standard','LEFT');
   $this-&gt;datatables-&gt;join('batches AS B','B.bat_id = C.batch','LEFT');
   $this-&gt;datatables-&gt;join('sections AS SE','SE.id = C.section','LEFT');
   echo $this-&gt;datatables-&gt;generate();  
  </code></pre>
  
  <p>I would like to know how we can write a sub-query inside these statements 
  thanks in advance</p>