I've created several classes by extending Zend_Db_Table_Abstract and I would like to get data out of 2 or more tables in 1 statement.

I know how to do this in SQL but I would like to know how to do this without using SQL and by using the classes that I've made.

Like this but then with 2 or more tables...

$table = new User();
$select = $table->select()->where('id_user = ?', $user);
$getUserDetails = $table->fetchRow($select);

You can make it by two ways first you can use select_api with joining Zend Framework: Documentation
Second way you can use Zend_Db_Table relationships which are much easier to use Zend Framework: Documentation

Thx for the information! Solved my problem...