I'm trying to join 3 tables from my database.

• database 1 : dkm (id, tgl, ref, etc)

• database 2 : order_product (kode_barang, packing, nama_barang, etc)

• database 3 : product (kodeprod, tglpakai, etc)

I'm already trying what other people do to join more than 2 table in CodeIgniter, but I got this error:

Error Number: 1066

Not unique table/alias: 'order_product'

SELECT * 
FROM `order_product` 
JOIN `order_product` ON `order_product`.`kode_barang` = `dkm`.`id` 
JOIN `order_product` ON `order_product`.`kode_barang` = `produksi`.`kodeprod`

This is my code:

Bukaka_model.php

public function getOrderProduct()
{
    $this->db->select('*');
    $this->db->from('order_product');
    $this->db->join('order_product', 'order_product.kode_barang = dkm.id');
    $this->db->join('order_product', 'order_product.kode_barang = produksi.kodeprod');
    $query = $this->db->get();
    return $query->result();
}