[bclinton]

Assuming you meant different tables, not different databases...

Have you tried to debug by using the profiler  $this->output->enable_profiler(TRUE) or sending $this->db->last_query() to the log?

Does the query shown by one of the above commands work if you run it manually at the command line or in something like PhpMyAdmin?