[eluser]foysal[/eluser]
Dear Insite FX
I tried your code. But I am getting only first table data.
Even I tried below codes in my model
Code:
$this->db->select('tbl_customer.*,tbl_sales.*');
$this->db->from('tbl_customer');
$this->db->join('tbl_sales', 'tbl_sales.customer_id = tbl_customer.customer_id','inner');
but i did not get data from both tables.
If you have any good tutorial on mysql inner join and codeigniter you can share it with me.
foysal