$db->select() >from(1st table) >join(2nd table, 結合条件) >leftjoin() >rightjoin() Zend Framework: Documentation: Zend_Db_Select - Zend Framework Manual

helperは機能を付け加える pluginはイベントを拾う