Is it possible in Yii to make such a request via updateAll()?

Question

Yii

Is it possible in Yii to make a query like

UPDATE
   `table1` 
LEFT JOIN
   `table2` 
ON  
  table1.id = table2.product_id
SET 
   table1.value  = table2.value

via updateAll() ?

Answer 1

updateAll doesn't support connections, do it via DAO and don't bother