I have 3 tables, where is the first one for user. In another two I have id_user, for product who created or activation who created. How I can show all data from these two tables with both username? I figure out how to join 2 tables, but third I have join twice and I don't know how. This is example for two tables:
$query=$this->db->select('*')
->from('activation')
->join('products','products.id_pro = activation.id_pro')
->order_by('id_key','DESC')
->get();
Table activation has column user_a with user id, and product has column user_p with user id. Sometimes is same user sometimes not. Any helps?