[eluser]Nathan Pitman (Nine Four)[/eluser]
Well I found a solution of sorts, If the JOIN is going to include anything more complex than a simple comparison I prepend it with "$this->db->_protect_identifiers = false;" and then append "$this->db->_protect_identifiers = true;".
Hacky but it works.