natural join with CI Active Record

[eluser]maesk[/eluser]
The select clause, when selecting also the userid from podcasts, probably should have been:

Code:

$this->db->select('podcasts.userid, title, description, length(audio), realname, creationdate, podid');

instead of

Code:

$this->db->select('userid, title, description, length(audio), realname, creationdate, podid');

and yes, it should work in one statement, as long as nothing is ambiguous. I couldn't test it but I'm glad you could make it work.