codeigniter where（）postgresql

What is the format in codeigniter

SELECT seq,
       code,
       discipline, 
       bacc 
  FROM "psced-disc" p 
       JOIN table2 t 
            ON p.code=t.psced_id 
 WHERE t.tableID=table2;

I already tried this and its working but without the WHERE clause

$this->db->select('seq, code, discipline,bacc');
$this->db->from('psced-disc p');
$this->db->join('table2 t', 'p.code=t.psced_id');
$query = $this->db->get();
return $query->result();

I want to add the WHERE t.tableID=table2;

Can anyone help me with this. I'm getting stuck at it.

try this code:

$this->db->select('seq, code, discipline,bacc');
$this->db->from('psced-disc p');
$this->db->join('table2 t', 'p.code=t.psced_id');
$this->db->where(array("t.tableID"=>"table2")); // or $this->db->where("t.tableID = 'table2'");
$query = $this->db->get();
return $query->result();