Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

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?



37.8k
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 http://phalcontip.com/discussion/36/how-to-use-subqueries-in-phalcon