is it possible to make a triple mjoin using the editor?
is it possible to make a triple mjoin using the editor?
IT Marcaria
Posts: 13Questions: 5Answers: 1
in Editor
When I try to do a triple join I get the following error:
"MJoin Link method cannot be called more than twice for a single instance"
This is part of the code:
.MJoin(new MJoin("ServiceTypes")
.Link("Taxes.idTax", "TaxesCountriesServices.idTax")
.Link("ServiceTypes.service_num", "TaxesCountriesServices.idServiceType")
.Link("PaisesTitulares.id", "TaxesCountriesServices.idCountry")
.Model<TaxesServiceTypes>()
The table TaxesCountriesServices have triple primary key: idTax, idServiceType, idCountry
Thank you.
This question has an accepted answers - jump to answer
Answers
I'm sorry to say not. I'm not sure there is even a workaround using a VIEW I'm afraid. I'll have a think about how it might be done.
Allan