Advanced relation

[Guest]

Hi,
I would like to create thi kind of SQL query: "select * from (A inner join B on A.F2=B.F1) inner join C on B.F2=C.1 where C.F1=1 and A.F4=4". Is it possible to create this with QxOrm? Is there any sample to do this?
Thanks

[Guest]

I think about to create a view in the database and create a new class wrapping this new view.

Is there another solution through QxOrm only?

[QxOrm admin]

Hi,

You cannot build this kind of SQL queries with QxOrm : you have to execute your query with QtSql module or create a view in your database.