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. ORM

query problem

i have a problem with a query...

how i can to do this query by create builder? 

SELECT * 
FROM TableA
INNER JOIN TableB ON 
TableB.campoB NOT IN(SELECT TableC.id FROM TableC)
LEFT JOIN TableC ON
TableA.id = TableC.id

is it possible?



58.4k
Accepted
answer

Hey man

Because you use subquery , so you can not use it but you can use Phalcon PDO or you can checktip here https://phalcontip.com/discussion/36/how-to-use-subqueries-in-phalcon