hi, i'm trying to use the criteria class of XOOPS to make inner and left joins, but i need to do it with 4 tables. is it posible?

eg
I have 4 tables ( table1 , table2 , table3 , table4 ) and i need to create this sql:

SELECT * FROM tabla1 t1
INNER JOIN table2 t2 ON ( t1.id = t2.parent_id )
LEFT JOIN table3 t3 ON ( t2.id = t3.parent_id )
LEFT JOIN table4 t4 ON ( t3.id = t4.parent_id )
WHERE t4.id = '22'


how can i do that with the criteria class?

I don't think the criteria can do that. It is mere about limiting selections and ordering (WHERE, ORDER BY, GROUP BY).

yep you're right. i read the entiry code xD