This is it's SQL code SELECT sec.title AS 'section', cat.title AS 'category', auth.Name AS 'author', modi.Name AS 'modifier', art . *
FROM article art INNER JOIN section sec ON sec.id = art.section_id INNER JOIN category cat ON cat.id = art.category_id INNER JOIN user auth ON auth.id = art.author_id LEFT OUTER JOIN user modi ON modi.id = art.modified_by WHERE art.id = '1' -- View this message in context: http://www.nabble.com/To-get-the-complete-row-using-join-in-Zend_Db_Table-tp25473213p25479412.html Sent from the Zend Framework mailing list archive at Nabble.com.