is it possible to make a triple mjoin using the editor?

is it possible to make a triple mjoin using the editor?

IT MarcariaIT Marcaria Posts: 13Questions: 5Answers: 1

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

  • allanallan Posts: 61,822Questions: 1Answers: 10,127 Site admin
    Answer ✓

    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

Sign In or Register to comment.