Nested leftJoin on Mjoin

Nested leftJoin on Mjoin

we0038we0038 Posts: 12Questions: 4Answers: 1

consider this one-to-many example

how do I make a left-join inside the Mjoin

my simplified tables
user (id, name)
task (id, description)
task_progress (id, task_id, user_id)

what I am trying to do is Mjoin task_progress on task
however, I was unable to get by leftJoin on task_progress.user_id

This question has an accepted answers - jump to answer


  • allanallan Posts: 48,883Questions: 1Answers: 7,123 Site admin
    Answer ✓

    I'm sorry - currently the Mjoin class doesn't provide the ability to do a left join to other tables.

    The workaround is to create a VIEW that would do the left join and let Editor read the data from that.


  • we0038we0038 Posts: 12Questions: 4Answers: 1

    thanks Allan. The view is just enough.

Sign In or Register to comment.