join-Statements mit Zend DB:
/*
* $db = a valid Zend_DB resource
* table1: foo (short: t1)
* table2: bar (short: t2)
* columns: column1, column2, column3
*/
$select = $db->select()
->from( array('t1' => 'foo'), // table name
array('t1.column1', 't1.column2', 't1.column3')) // selected columns
->join( array('t2' => 'bar'), 't1.column1 = t2.column1') // JOIN bar t2 ON t1.column1 = t2.column1
->where('t2.user_id = ?', $var) // WHERE t2.userid = '$var'
->order('t1.column ASC'); // ORDER BY t1.column ASC