Get fields of different table in find

Question

Get fields of different table in find

Jonathan Vandal Dec '15

Created Dec '15	Last Reply Dec '15	Replies 2	Views 506	Votes 0

Jonathan Vandal 41.3k

Dec '15

I want to use a find and in my condition I want to get a field of the another table. I don't want to use a QueryBuilder or what. Just a find(). So it is possible do to this query in my find condition ?

SELECT *

FROM table1 t1 INNER JOIN table2 t2 ON (t1.id_t = t2.id_i)

WHERE t2.field = 'test'

xaero · Answer 1 · 2015-12-16T04:30:25-07:00

xaero
31.3k

Dec '15

see the manual: https://docs.phalcon.io/en/latest/reference/phql.html#using-raw-sql

Wojciech Ślawski · Answer 2 · 2015-12-16T09:04:56-07:00

Find is for finding data from model. If you wanna find data from another table/model then you are doing something seriously wrong here. If you wanna do joins then use queryBuilder.