/** * Description... * * @return void **/ public function clientListQuery() { return M('Db')->createQuery($this->_mapper->table('client') . ' cl')->join('cl', 'left join ' . $this->_mapper->table('company') . ' com on com.id=cl.company_id')->what('cl.*, com.name as company'); }