konto usunięte
Temat: Jak dodać dodatkowe pole w select ?
mam kod:$select = $this->objDB->select()
->from(array('a1' => 'tabela1'), array(
'field1' => new Zend_Db_Expr('MIN(a1.added::date)'),
'field2' => new Zend_Db_Expr('SUM(a1.test) / COUNT(a1.test2)'),
))
->join(array('a2' => 'table2'), 'a2.id = a1.id_costam', array())
->where('a1.added::date = NOW()::date');
return $this->select($select,true);
Jak teraz zrobić takie zapytanie jak to poniżej ?
SELECT MIN(a1.added::date), SUM(a2.value), (SELECT SUM(a1.value2) FROM tabela1 WHERE tabela1.id_costam = 2) FROM tabela1 a1 JOIN tabela2 a2 ON (a2.id = a1.id_costam) WHERE a1.added::date = NOW()::date
jak dodać ten wpis:
(SELECT SUM(a1.value2) FROM tabela1 WHERE tabela1.id_costam = 2)
do zenda jako nowe pole