php - Zend - SELECT 语句 "AS"

Question

我有以下查询

(select informed from evaluations where releases_id="1234") AS INFO

ZEND框架字查询:

$get_details = $db->select()
                ->from(array('INFO'=>'evaluations'), 'informed')
                ->where('releases_id =?',"$row[id]");

上面给出

SELECT `INFO`.`informed` FROM `evaluations` AS `INFO` WHERE (releases_id ='1214')

但我想得到

(select informed from evaluations where releases_id="1234") AS INFO

任何人都可以指导我构建正确的查询吗？

Answer 1

从您的请求开始:

$get_details = $db->select()
            ->from(array('INFO'=>'evaluations'), 'informed')
            ->where('releases_id =?',"$row[id]");

尝试重命名您的子查询，它应该可以工作:

$get_details = $db->select()->from(array('INFO' => $get_details))