ZEND_DN and Multiple table JOIN

I am using the ZEND_DB adapter class and I creating a query with a join clause. When I call my  the adapter class it run forever.

I am not using db_select. This my own create query. However, if I call the method without any join it works.

Here is the class and function

class DatabaseService
      function DatabaseService($dbinfo,$dbname="")
            $dbConfig = array(
                'host'     => $this->host,
                'username' => $this->username,
                'password' => $password,
                'dbname'   => $this->dbname );
            $this->db = Zend_Db::factory($this->adapter, $dbConfig);       
            catch(Zend_Exception $e)
                  $this->error = $e->getMessage();
                  return false;
   public function fetchall($sql)
            $res= $this->db->fetchAll($sql);
            return $res;
Who is Participating?
SiemensSENConnect With a Mentor Author Commented:
I  drop and re-create the index
Please post the query.

Does the query work in phpMyAdmin or QueryBrowser?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.