join problem

[eluser]mandrake[/eluser]
Hi,
excuse me for my english.

I use Activerecord in my model

Code:

$this->db->select('*');
$this->db->from('authors');
$this->db->join('clienti_authors_related', 'clienti_authors_related.author_id = authors.author_id AND clienti_authors_related.cliente_id = 1');

Result: 0 records.

I try the query result (last_query()) in phpmyadmin:

Code:

SELECT *
FROM authors
JOIN clienti_authors_related ON clienti_authors_related.author_id = authors.author_id AND clienti_authors_related.cliente_id = 1

Result: 2 records.

why?

Is this a bug?

Thanks…