how can i apply join query in codiginator with where clause?

`

$this->db->select('*');
      $this->db->from('doctor_list');
      $this->join('status','doctor_list.id != status.doctor','inner');
      $this->db->where('status.app_date',$_POST['date']);
      $query=$this->db-get();

`

I used this...I am getting call to undefined method