[eluser]lenwood[/eluser]
[quote author="dmorin" date="1273007459"]
Code:
$this->db->like('entry_id', $row->id);
Why are you doing "like" here? when comparing ids, you should use a straight "column = value".[/quote]
That's the only way that I could get the query to run. I don't recall the specific error that I was getting, but when I originally wrote this I was using $this->db->where. I haven't tried it again since updating to the join statements.
I'll try that, as well as your updated query tomorrow and let you know how it goes.