I have two models on which I want to perform an inner join. However, when I try to visualize the results, I get the error "Error running query." The query builder also appears unable to generate the query.
this is the general schema of the question:
It's notable that when I perform the join with the exact opposite order on the same columns, no problems arise. Also, the database I'm using is MongoDB.