title: How to join two tables with ssp.class.php
body: <p>I started using <a href="http://datatables.net" rel="noreferrer">DataTables Table plug-in for jQuery</a> and got some problems. I am using example code from <a href="https://datatables.net/examples/server_side/simple.html" rel="noreferrer">here</a>.</p>
  
  <p>I have MySQL table witch looks like that:</p>
  
  <blockquote>
    <p>id | name | father_id</p>
  </blockquote>
  
  <p><code>father_id</code> is <code>id</code> value in same table only in different row. So if I want to know father name i have to search in same table <code>WHERE id = father_id</code>. But what DataTable does it just show the contents of MySQL table as it is.</p>
  
  <p>In my DataTable i want to show data like that:</p>
  
  <blockquote>
    <p>id | name | father_name | father_id</p>
  </blockquote>
  
  <p>So when DataTable takes data from MySQL table, but before it creates table I want to change column value which at that time is value of <code>father_id</code> in the same row in MySQL. I want too add <code>father_name</code> by searching for it with particular <code>father_id</code>.</p>