You wouldn't be able to use Zend_Db_Table::update(), but I think you could use the adapter's update() method if you pass in the table names as a Zend_Db_Expr() object. You might also be able pass in the two table names as an array.
You may also have to use Zend_Db_Expr for the data and where clauses too, but not sure.... I typically go the second route with a hand-written query. :-) Cheers, David -- View this message in context: http://zend-framework-community.634137.n4.nabble.com/Complex-UPDATE-statement-Best-method-tp3347426p3347470.html Sent from the Zend Framework mailing list archive at Nabble.com.
