mito icon indicating copy to clipboard operation
mito copied to clipboard

Multiple Joins

Open daninus14 opened this issue 1 year ago • 2 comments

I would like to be able to do multiple joins with mito. Right now, includes only allows for one join, but for a regular m-n relationship, where we have tables A, A_TO_B, and B, I want to be able to include table B as well.

In SQL this would be just

SELECT *
FROM A
LEFT JOIN A_TO_B
ON A.ID = A_TO_B.A_ID
LEFT JOIN B
ON A_TO_B.B_ID = B.ID;

Right now, unless I misunderstood something, the includes only allows for one join. I think there should be a way to simply have another includes, within some expression to provide the context of which class is including which other class, to allow for the second join

daninus14 avatar Aug 22 '23 14:08 daninus14