How to apply inner join for four tables?

[pranay2210]

[simolus3]

You you just use

select(firstTable).join([
  innerJoin(secondTable, condition),
  innerJoin(thirdTable, condition),
  innerJoin(fourthTable, condition),
])

Do you need anything special I'm missing?

[pranay2210]

Could you please provide me an example so that I could find it more clear to use. Thank you

[DougSiqueira]

You you just use

select(firstTable).join([
  innerJoin(secondTable, condition),
  innerJoin(thirdTable, condition),
  innerJoin(fourthTable, condition),
])

Do you need anything special I'm missing?

And when I have three many-to-many relationships and one to many relationships. How to make this inner join?

[DougSiqueira]

It is related to my problem: #345

[simolus3]

@pranay2210 Can you describe your scenario some more? Like what kind of tables you have and what query you need. If I know more about your use case I can write a fitting example.