Joining tables with Active Record works fine, but how do I add a WHERE clause into the mix?

[eluser]TheFuzzy0ne[/eluser]
id looks ambiguous to me. I'd imagine you'd need to use something like:

Code:

$this->db->where('jobtypes.id', $this->uri->segment(4));

or

Code:

$this->db->where('categories.id', $this->uri->segment(4));