title: how write whmcs inner join 'where condition'
body: <p>whmcs inner join 'where condition', </p>
  
  <p>both table having same field.</p>
  
  <p>how distinguish table name in where condition ?</p>
  
  <p>tried this one , </p>
  
  <pre><code>$table = "tblclients";
  $fields = "id,firstname,lastname,domain";
  $where = array(
     "lastname"=&gt;array("sqltype"=&gt;"LIKE","value"=&gt;"Demo"),
     "companyname"=&gt;array("sqltype"=&gt;"NEQ","value"=&gt;""),
  );
  $sort = "id";
  $sortorder = "ASC";
  $limits = "0,5";
  $join = "tblhosting ON tblhosting.userid=tblclients.id";
  $result = select_query($table,$fields,$where,$sort,$sortorder,$limits,$join);
  </code></pre>
  
  <p>how specify table name in where condition ?</p>