Zend_Db query for joining two tables
===

I have 3 tables:

user[id, name, username, password, role]

event[id, date, location, name]

participant[id, userId, eventId]

And I want to select all the events on which a given user participated. For this I have created an sql query which I tested and returned the desired result.

    SELECT * FROM event
    INNER JOIN participant ON participant.eventId = event.id
    WHERE participant.userId = $id

After this I tried turning it into a zend request which should have worked according to other post from this site.

    public function getEvents($id) 
    {
        $select = Zend_Db_Table::getDefaultAdapter()->select();
        $select->from('event')
               ->joinInner('participant','participant.eventId = event.id')
               ->where('participant.userId = ?', $id);
        return $select;
    }

I'm using "PDO_MYSQL" as an adaptor and I don't have any problem with inserting into a table, selecting an entire table or just specific rows. But the above code seems to do a simple fatchall() insted of what I want. And whatever I try changing on it it always returns the event tables content.

My question is: Does anyone have an idea why this could be happening?