U2Kの覚え書き Zend_Db_Select でFROM句に副問合せ(subquery)

すごい迷ったのでメモ。 $selectA = $db->select() ->from(array('u' => 'user'), 'name') ->where('u.id >= 5'); $selectB = $db->select() ->from(array('u' => 'user'), 'name') ->where('u.id < 5'); $sqla = $db->select()->union(array($selectA, $selectB)); $select = $db->select() ->from( array('u2' => $sqla), array('cnt' => 'COUNT(*)') );; echo $select->__toString().''; 出力SQL SELECT COUNT(*) AS "cnt" FROM (SELECT "u".

[mimesis]

サブクエリの書き方

[bigbro]

Zend_Db_Selectでサブクエリ