title: codeigniter where() postgresql
body: <p>What is the format in codeigniter </p>
  
  <pre><code>SELECT seq,
         code,
         discipline, 
         bacc 
    FROM "psced-disc" p 
         JOIN table2 t 
              ON p.code=t.psced_id 
   WHERE t.tableID=table2;
  </code></pre>
  
  <p>I already tried this and its working but without the WHERE clause</p>
  
  <pre><code>$this-&gt;db-&gt;select('seq, code, discipline,bacc');
  $this-&gt;db-&gt;from('psced-disc p');
  $this-&gt;db-&gt;join('table2 t', 'p.code=t.psced_id');
  $query = $this-&gt;db-&gt;get();
  return $query-&gt;result();
  </code></pre>
  
  <p>I want to add the <strong>WHERE t.tableID=table2;</strong></p>
  
  <p>Can anyone help me with this. I'm getting stuck at it.</p>