How to select data from joined table

it should be no problem unless not meet condition for $to,
let debug it. first you can check the real query generated

$db = db_connect(); or $this ->db (if inside model)

$db->showLastQuery(); or $this->db->getLastQuery();

Try the generate query on external program like phpmyadmin or HeidiSsql to check error