How can Zend Db be used to update multiple tables using joins?

advertisements

Is there an equivalent to the following SQL using the Zend_Db modules?

UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;

The mysql manual states

... multiple-table UPDATE statements can use any type of join permitted in SELECT statements, such as LEFT JOIN.


You can always execute a query string.

$db->query("UPDATE items,month SET items.price=month.price WHERE items.id=month.id")

Disclaimer: I haven't tested it.