Page 1 of 1

how to query with deep relation table

PostPosted: Mon Aug 22, 2011 8:13 am
by 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

Re: how to query with deep relation table

PostPosted: Mon Aug 22, 2011 9:32 am
by 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...