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 ?
FROM table1 t1 INNER JOIN table2 t2 ON (t1.idt = t2.idi)
WHERE t2.field = 'test'