nethero

public function test()
        {
            $query = $this->db->select('p.*' )
                    ->from('products p')
                    ->join('orders o', 'o.order_id = p.order_id')
                    ->join('alias a', 'a.alias_id = p.alias_id')
                    ->get();

            print_r($query->result_array());

        }