We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Beginners

how to use subqueries???

Hi!!!

how to use subqueries??? such as:

SELECT * FROM some_tbl WHERE some_tbl.column = ANY(SELECT id FROM get_ids_from_function(:some_param:))

such queries are executed only by Phalcon\Db???

1


21.8k

I think subquery are not possible for the moment.

Also, here is a blog entry : https://blog.phalcon.io/post/56351424566/the-road-ahead subquery will be available with versions 1.3 or 1.4