Subqueries - Select * from subquery

Question

Mateusz Błaszczyk Jan '16

Created Jan '16	Last Reply Jan '16	Replies 1	Views 924	Votes 0

Mateusz Błaszczyk 14.1k

Is it possible to run query:

$this->modelsManager->executequery('SELECT avg(a) FROM (SELECT sum(a) AS a, b, ,c FROM ...) AS sub')

?

Important part is SELECT FROM subquery. Beacuse I got exception:

Phalcon\Mvc\Model\Exception: Syntax error, unexpected token (, near to 'SELECT sum(a) AS a...

So is it possible to run such query with modelsManager?

I use Palcon 2.1.x

Thien Tran · Answer 1 · 2016-01-20T09:07:29-07:00

Hello

You can try edit your sql the above to be like this:

$sql = "SELECT avg(a) FROM (SELECT sum(a) AS a, b, ,c FROM ...) AS sub";
$this->modelsManager->executequery($sql)