Data can't display when I use join table in codeigniter and flexigrid

[eluser]beben[/eluser]
Flexigrid can't perfom data when I use join 3 tables in my model. Anyone can help me ? Or flexigrid only can perform data for no relation table. All the flexigrid tutorial in codeigniter that i've found before just use one table, or it's any tutorial that use more than one table or join table. Thanks.

This is my model code.

Code:

$this->db->select("bridging.id_kwl_13 AS ID, data_hpb_2012.PRSH AS KODE_PERUSAHAAN, mkbki_dig10.desk10 AS JENIS_BARANG_BARU, data_hpb_2012.NAMA_JNS AS JENIS_BARANG_LAMA, data_hpb_2012.NAMA_KWL AS KUALITAS,SATUAN,data_hpb_2012.HRG1,data_hpb_2012.HRG2");

    $this->db->from('data_hpb_2012');
    $this->db->join('bridging', 'bridging.ID_KWL_10 = data_hpb_2012.ID_KWL_10');
    $this->db->join('mkbki_dig10', 'mkbki_dig10.dig10 =  MID(bridging.id_kwl_13,1,10)');

    $this->CI->flexigrid->build_query(TRUE);

    //Get contents
    $return['records'] = $this->db->get();


    //Build count query
    $this->db->select("count(IDEN_HPB) as record_count");
    $this->db->from('data_hpb_2012');
    $this->db->join('bridging', 'bridging.ID_KWL_10 = data_hpb_2012.ID_KWL_10');
    $this->db->join('mkbki_dig10', 'mkbki_dig10.dig10 =  MID(bridging.id_kwl_13,1,10)');
    $this->CI->flexigrid->build_query(FALSE);
    $record_count = $this->db->query($SQL);
    $row = $record_count->row();

    //Get Record Count
    $return['record_count'] = $row->record_count;

    //Return all
    return $return;

[eluser]Unknown[/eluser]
Please add a join type in the end for example

Code:

$this->db->join('bridging', 'bridging.ID_KWL_10 = data_hpb_2012.ID_KWL_10','inner');
or
$this->db->join('bridging', 'bridging.ID_KWL_10 = data_hpb_2012.ID_KWL_10','left');
or
  as required joins