how to query with deep relation table

[qsimul]

Hi,
if I have table A,B and C where the relation are
A -- many to one ---->B -- one to many ----->C.
and if I want to query like this statement = "select * from A inner join B inner join C".
it is possible to do that in QxOrm ?

I am try to check using fetch_all_with_relation but it's only can fetch relation A and B, not C.
Please advise.

Thanks

[QxOrm admin]

Hi,

No you can't, this is not supported yet by QxOrm library (1.1.7).

But, in your database, you can create a view.
Then just map a C++ class to this view...